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