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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Partitioned Indexes
Thanks guys. Very helpful posts. I should have given a little more info on this. 1. Queries will be more focussed on aggregates on individual periods. (i.e will not span period to period). 2. No DDL, except for the addition of new partitions and the dropping of old ones. I am reckoning that...- daddymack
- Post #4
- Forum: Oracle: All versions
-
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
-
Matching character "quota"
you could try replacing the line pos=match($0,a,"\'") with pos=match($0,"\'") and it should work also -
-
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... -
Bucket Lines with same pattern to one file.....
awk '{c=tolower($2);print $0 >> c".txt"}' file remember to remove the files from the prvious run before you process the file again.(it just keeps appending to the files) -
How to extract file names from a fiel and remove them
xargs rm < filename where filename is the name of file containing the files to be deleted.. -
Hi all, I want to check out whet
predefined keywords should be in a file called predef.txt awk script is sea.sc BEGIN { while ((getline kw_line < "predef.txt") > 0) kw[++i]=tolower(kw_line) } { for (j=1;j<=i;j++ ) printf ("%d ",(index(tolower($0),kw[j]) > 0 ? 1 : 0)) printf ("\n") } run from... -
subtracting two dates
Thanks CaKiwi for the post, but in order to keep processing time to a minimum, I have decided to go with the idea of using a lookup table of epoc values with the key MON-YYYY%NNNNNN where NNNNNN is the number of days from the end of the previous month since 1/1/1970 e.g JAN-1970%0 FEB-1970%31... -
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
Sorry for the confusion but I think I know the reason now, apparently if you even reference an array element,it will create it with a null value. You have to check it first. If you refer to an array element that has no recorded value, the value of the reference is `""', the null... -
phantom move between arrays
Sorry but the code in the above post interpreted "[ i ]" as italics and hence displayed incorrectly.. have replace with [j] and resubmitted BEGIN { call[1]=10 call[2]=20 call[3]=30 call[4]=60 call[5]=70 dat[2]=20 dat[3]=30 dat[4]=60 dat[5]=70 dat[6]=80 print "elements in dat... -
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... -
Index on date-column isn't being used
If the table is partitioned on the "time" field, then your select statement would do a full scan of the partition If your table is not partitioned on time, try doing the following select statement.. select name, age, time from table_a where time = to_date('2002-02-25...- daddymack
- Post #12
- Forum: Oracle: All versions
-
selecting substrings and changing them
you could try this as well awk -F: '/^Info/{print $0}/^Delta/{gsub(/[A-z]*[|]*/,"",$2); print $1":"$2 }'
