Search results for query: *

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...

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

you could try replacing the line pos=match($0,a,"\'") with pos=match($0,"\'") and it should work also

Thanks Krunek. Thats worked a treat.

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...

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)

xargs rm < filename where filename is the name of file containing the files to be deleted..

predefined keywords should be in a file called predef.txt awk script is sea.sc BEGIN { while ((getline kw_line < &quot;predef.txt&quot;) > 0) kw[++i]=tolower(kw_line) } { for (j=1;j<=i;j++ ) printf (&quot;%d &quot;,(index(tolower($0),kw[j]) > 0 ? 1 : 0)) printf (&quot;\n&quot;) } run from...

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...

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 ?

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 `&quot;&quot;', the null...

Sorry but the code in the above post interpreted &quot;[ i ]&quot; 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 &quot;elements in dat...

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...

If the table is partitioned on the &quot;time&quot; 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...

you could try this as well awk -F: '/^Info/{print $0}/^Delta/{gsub(/[A-z]*[|]*/,&quot;&quot;,$2); print $1&quot;:&quot;$2 }'