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 TouchToneTommy 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: *

  1. dechrist

    Duplicates and Ranking

    I have three tables I'm trying to join together by ID. TableA has duplicates based on Col2 and Col3. TableB has multiple entries per ID which I need to sum. TableA ID Col2 Col3 1 123 99999 2 123 99999 3 abc 11111 4 abc 11111 TableB ID Col4 1 30 2 20 2 100 3 50 4 25 TableC ID Col5 1...
  2. dechrist

    Oracle SQL Developer - sort stored procedures in window

    When running a procedure from inside Oracle SQL Developer (by clicking the green play button), the Run PL/SQL window pops up with the list of stored procedures in the package. They are not sorted, which if you have a lot of procedures it can be a real pain to scroll through to find the one...
  3. dechrist

    Oracle SQL Developer - Run PL/SQL - Target sort

    When running a procedure from inside Oracle SQL Developer (by clicking the green play button), the Run PL/SQL window pops up with the list of stored procedures in the package. They are not sorted, which if you have a lot of procedures it can be a real pain to scroll through to find the one...
  4. dechrist

    Get OUT parameter from stored proc in windows script

    Thanks! That did help my effort. Here's my final batch script: sqlplus -s <usr>/<pswd>@SID @RunProc.sql> output.txt set /p result=<output.txt del output.txt echo RetVal = %result% > log.log 2>&1 RunProc.sql set serveroutput on format wrap set verify off declare quadrupled...
  5. dechrist

    Get OUT parameter from stored proc in windows script

    The procedure is already defined in the database. I don't understand how the value (named quadrupled in your example) can be accessed from a windows batch script. I have the following a windows batch script: sqlplus -l -s <usr>/<pswd>@SID @RunProc.sql And RunProc.sql contains: declare...
  6. dechrist

    Get OUT parameter from stored proc in windows script

    In windows script, how can you get the value of the output parameter from calling a stored procedure? Here's a test procedure I've been working with: PROCEDURE f (p IN NUMBER, y OUT NUMBER) IS BEGIN y:=4 * p; END; I want to get the value y into a variable in the windows script.
  7. dechrist

    Check characters not in list

    How can I check if a string contains characters not in a list? My string can contain a-z, A-Z, 0-9 and @, #, and a space, but nothing else. Valid strings: 123@valid another1 Invalid strings: 1 invalid* another $ one Doing it all inside a SQL statement (or two) is preferred.
  8. dechrist

    Pivot

    I have the following in a table in Teradata (the actual table has about 60 columns): Dept Group Col1 Col2 100 1 A D 100 2 B E 200 1 C F I would like to get: Dept 100 100 200 Group 1 2 1 Col1 A B C...
  9. dechrist

    Remove warning when using RUN FILE to logon

    Is there any way to remove the below warning message when using the RUN FILE command to retrieve log on information? Thanks! .RUN FILE = 'C:\Path\LogonInfo.txt'; +---------+---------+---------+---------+---------+---------+---------+---- .LOGON server/user...
  10. dechrist

    command line arguments

    I want to use command line arguments to pass the user name and password to bteq, fastload, multiload, etc. scripting. Does anyone have a good example how to do? Thanks in advance.

Part and Inventory Search

Back
Top