Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Partitioned Indexes
I am creating a table at the moment (.. dl_field varchar2(10) fl_field varchar2(10) period varchar2(4) ..) if i partition the table on the period field, and I then create indexes on dl_field and fl_field, should these indexes be partitioned also. thanks in advance Niall- daddymack
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
rounding problem
Can anyone shed any light on this, essentially what I am trying to do is read in a column of numbers and print out the number left padded with zeroes(width of 15) and no decimal place i.e INPUT 0.69 000000000000069 7.1 000000000000710 5 000000000000500 The below script is returning... -
subtracting two dates
Does anyone know of a quick way of subtracting two dates from one another in awk i.e date format is YYYYMMDD in order to find the number of days between them ? -
phantom move between arrays
this has me flumoxxed, I set up two arrays, call and dat. there is one exclusive element in both, and 4 inclusive, but when I delete from one of the arrays, the exclusive element magically moves to the other array. Is this a bug in awk ? BEGIN { # call[1] is exlusive to call array call[1]=10...
