Search results for query: *

John, Thanks for your response. Replication is not a possibility due to limited resources on the server and network bandwidth availability. Al

I am working on an application that is hosted on same DB server as another application. We share this server with this another app, but we are under different schemas. We have a need of RO access a table or materialized view or view under the schema of this another application. What would the...

feherke, Thanks a lot. It makes sense. In fact, after posting this question, I went and ran this code few times in Eclipse debug mode and stepped through it. It showed me exactly what you have highlighted in your answer i.e. this in a method refers to the calling object itself. Also, I have...

I have this piece of code. public class Q { static int x = 11; private int y = 33; public static void main(String args[]) { Q q = new Q(); q.call(5, 555555); System.out.println("Value of x " + q.x); System.out.println("Value of y " + q.y); } public void call(int x, int y)...

The problem is that it ignores the lines in a .ksh or .sql file for example: Select * from IMD.SATURN_4500_a Because it has IMD. before and _4500_a at the end I still want it to return above line in search results because it has saturn in it. The idea is to automated the search and result...

okay. That works. One last thing. If my *.sql.* or *.*ksh file has: IMD.SATURN SATURN_4500_a Select * from IMD.SATURN_4500_a How can I pick all these 3 lines in my results by just having below in my keyword.txt file: saturn Thanks!

John, Thanks. Actually, I wanted to simultaneously search within *.sql.* and *.*ksh files. I tried to do this, but it did not work. nawk -F'[ ()+-;]' -v words=$RSVWDS ' BEGIN{n=0; while ((getline line < words ) > 0){ n=n+1; rw[n]=line;} close(words);} {for(k=1;k<=NF;k++){ l0=toupper($k)...

...it to read lower case keywords from txt file and search them as well. 2) In the same script I want to search keywords not only in .ksh files, but *.sql.* I tried, but can’t seem to find how to include item 1 & 2. Any help will be highly appreciated. I am using solaris 10. Sample...

Hey Andy, Yes it does. Thx for the suggestion...Here is the fixed version for both tables: Table X_1 (PRIMARY KEY A_1) A_1 A_2 A_3 A_4 8998A 01/01/2014 XYXY REST WELL BHYXTY 04/20/2015 UUUU PEACE 99999 02/06/2014 LLLL FUN TABLE X_2 (F_1 & F_2 PRIMARY KEY) F_1 F_2 F_3...

NEWBIE to ORACLE SQL and I have a following situation: Table X_1 (PRIMARY KEY A_1) A_1,A_2,A_3,A_4 8998A,01/01/2014,XYXY,REST WELL BHYXTY,04/20/2015,UUUU,PEACE 99999,02/06/2014,LLLL,FUN TABLE X_2 (F_1 & F_2 PRIMARY KEY) F_1,F_2,F_3,F_4,A_2,A_3,A_4 8998A,0,TEST,XXX,NULL,XYXY,NULL...

Hi, I would like to remove all the lines in a file that contains letters (upper case) KJ at postions 6-7 from the begging on line. an example would be: 1ABNPKJLDS9PORT_SIL 200708800 copu 1PORPKJLDUS9PORT_UYT 200700000 KLPU 1ABTPKJLDS9JOB_SIL 200708800 CPOI 1POIPKJLDUS9PO_UYT...

SkipV, Worked like a charm. Thanks a lot for taking time and answering my question. I learned something today!! Al

SkipV, Thanks for your reply. I tried the formula, but it kept returning FALSE for everything in the list. Did I do something wrong? Al

I have a one long list of alphanumeric data approx. 3000 some rows in EXCEL 2010. Following is an example: PP5690 AG8908 KJ3459 EVENTHORIZON LISTnumber UI3409 IL0965 I want to remove all rows that DO NOT conform to value like PP5690 i.e. First two characters are alpha and next four are...

LKBrwnDBA, thanks a lot. Its very much appreciated. Is there a way to handle upper case and lower case words in reserved_words.txt? Al

LKBrwnDBA, Your previous code was returning results for first word in reserved_words.txt. I replaced it with new code you recommended and it does not yield anything...something is not right here? I am 100% sure some scripts has words that I put in reserved_words.txt file. Al

Also, for some reason its just searching the first word in reserved_words.txt and stop after that. So, right now my reserved_words.txt looks like this: CONNECT day_of_week WARNING result only show CONNECT or DIRECTCONNECT etc. I know for sure rest of the words are used in .ksh file under that...

I am curious...can I restrict searches to exact word for example right now its picking up DIRECTCONNECT due to CONNECT being in reserved_words.txt So, if I put CONNECT then I only want results with exact word CONNECT and nothing else. Thx

oh crap. Thanks PHV.

...0){ n=n+1; rw[n]=line;} close(words);} {l0=toupper($0); w=0; for(i in rw){if(index(l0,rw[i])>0) w=w+1;} if(w>0){print FILENAME": "FNR" : "$0} }' *.*ksh scan_words.ksh /nto/scripts/ Error: awk: no program given scan.ksh[17]: BEGIN{n=0; while ((getline line < words ) > 0){ n=n+1...