Search results for query: *

Works like a CHARM !!! Thanx a great lot ! -Maria

Ygor ...thanx for the response ... 1) It works fine if the table name is NOT the last line in a paragraph ... so it didn't select for TABLE_D, TABLE_E (also for TABLE_A1) ... for the rest, it selected fine .. 2) When the temp.lst is of the form : IF V_SEQ_NAME = 'TABLE_A_1SQ' THEN SELECT...

Hi, 1) I have a file (temp.lst) like this : TABLE_A1 TABLE_C TABLE_D TABLE_B TABLE_A TABLE_E TABLE_G TABLE_F TABLE_A2 I want to select the paragraph which has exactly TABLE_A in it ... (not TABLE_A1 or TABLE_A2) The current solution I have is : cat temp.lst|sed -e '/./{H;$!d;}' -e...

Thanx , it works like a charm ! -Maria

Hi, How to suppress an error message while using shell? eg) ll -rt bcopy_1/temp_db_*.sql > bcopy_1/chk.lst bcopy_1/temp_db_*.sql not found I don't want the error message "bcopy_1/temp_db_*.sql not found" to appear ... If the file isn't there, it should just create a 0 byte output file...

Thanx a lot Mike for your posts ... I really appreciate it ... With help from you first post, I could write a shell to do what I wanted to ... The logic is as follows : 1) I have a master directory which holds all SQLs 2) I then have 10 (temporary) subdirectories under this directory 3)...

Thanx Mike, How does running in background help ? and how do we ensure that 2 or more processes won't execute the same SQL ? I had created another file from the SQL list file with an extra column as status. Whenever a SQL is processed by a session, it would update this column as "IN PROCESS"...

Hi, I have a list of SQLs in a file. I need to open 10 Oracle sessions that read from this file in such a way that each session doesn't read or execute a SQL that's being handled by another session. Initially I tried by allocating a set number of SQL's to each of the sessions. This worked...

Ygor's second solution also works Great ! Mike's solution doesn't work ... Thanx a lot for all your help -Maria

Ok, I got it : awk '/^conn /{c=$0}/^(create|grant|drop) /{if(c){print "\n" c ;c=""}print $0}' file1 > file2 Thanx -Maria

Hey, How do I select create, grant statements along with drop ? From this : conn scale/****@bill; conn audit/****@accounts; conn ledger/****@receive; drop synonym tested; drop synonym checked; create synonym test for scale.book; grant select on test to public; conn rule/****@stats; drop...

That worked like a charm ! Thanx a great bunch !!! -Maria

Hi, I have a file which contains the following : conn scale/****@bill; conn audit/****@accounts; conn ledger/****@receive; drop synonym tested; drop synonym checked; conn rule/****@stats; drop synonym booked; drop synonym billed; drop synonym removed; ..................... 1) I want the...