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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by atltechie

  1. atltechie

    Ranking

    Hello, I am trying to rank subscribers calls based on minutes. I want the rank to be within the each subscriber not based on every call every call in the table. I used the following query and it seems to be ranking the entire table based on minutes. Any ideas??? SELECT C1.SUBSCRIBER...
  2. atltechie

    Shell script output

    In the above script is it possible have separate list files for each SQL output?
  3. atltechie

    Shell script output

    Thanks for your help!!
  4. atltechie

    Shell script output

    Thanks....it worked!!!!! I had another question can I add the date and time to the log file the sql file is spooling to? spool products; SELECT * FROM PRODUCTS; spool off;
  5. atltechie

    Shell script output

    Question, How do I prevent my shell script from printing the results of a sql statement from on the screen. the following is my script #!/bin/ksh sqlplus -s user/password << EOF @/var/test1.sql @/var/test2.sql exit EOF In the sql files I am spooling to a file. Thanks
See more

Part and Inventory Search

Back
Top