Search results for query: *

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

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

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

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

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

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.

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.

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

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

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.