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 gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: AlStl
  • Order by date
  1. AlStl

    Accessing Objects in another schema under same database

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

    Accessing Objects in another schema under same database

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

    Instance variable scope - Confused

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

    Instance variable scope - Confused

    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)...
  5. AlStl

    Shell Script to Search

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

    Shell Script to Search

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

    Shell Script to Search

    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)...
  8. AlStl

    Shell Script to Search

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

    Update via a VIEW or Direct Update

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

    Update via a VIEW or Direct Update

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

    SED line delete - string at certain position help

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

    Excel help in removing certain type of data

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

    Excel help in removing certain type of data

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

    Excel help in removing certain type of data

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

    awk script help for seaching reserved words

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

    awk script help for seaching reserved words

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

    awk script help for seaching reserved words

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

    awk script help for seaching reserved words

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

    awk script help for seaching reserved words

    oh crap. Thanks PHV.
  20. AlStl

    awk script help for seaching reserved words

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

Part and Inventory Search

Back
Top