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)...
I have a script (find_keyword.ksh) that reads data from a txt (keyword.txt) file and produces results if any word in txt files matches in the directory containing files that end with .ksh
I pass directory path at the time of script execution.
I am facing two issue that I would like some tips...
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...
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,
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
Thanks all for your input. I appreciate it. Question for LKBrwnDBA.
I created scan_words.txt and added some words in it and here is my code, but i am getting an error
#!/bin/ksh
# scan_words.ksh
# Parameter: 1- Scripts directory
SCRIPTDIR=$1
# Location of the reserved words file...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.