10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
We have a procedure e.g. prc_synonym created in Oracle 12c Database. I want to do small change in procedure through Unix. I have that changed procedure (prc_synonym) in proc.sql file. Want to recompile that procedure through Unix so that changes should reflect in existing procedure in... (10 Replies)
Discussion started by: Aparna.N
10 Replies
2. Shell Programming and Scripting
hi Guys,
is there a way to pass parameter into oracle store procedure by reading date range in file and increment accordingly. Something like this
file.txt
01-JAN-2015
03-JAN-2015
sqlplus -s user/pwd@DB
execute TEST( to_date( '01-JAN-2015, 'dd.mm.yyyy' ), to_date( '03-JAN-2015', ... (1 Reply)
Discussion started by: rohit_shinez
1 Replies
3. Shell Programming and Scripting
I have 2 files namely branch.txt file & RXD.txt file as below
Ex:Branch.txt
=========================
B1,Branchname1,city,country
B2,Branchname2,city,country
B3,Branchname3,city,country
B4,Branchname4,city,country
B5,Branchname5,city,country
RXD file : will... (11 Replies)
Discussion started by: satece
11 Replies
4. Shell Programming and Scripting
Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison.
Thanks in advance for your help.
File A
A,B,C,45,46... (2 Replies)
Discussion started by: ady_koolz
2 Replies
5. UNIX for Dummies Questions & Answers
Hi,
My stored procedure returns a value.
How to retrieve the value and display in unix.
Stored procedure
CREATE OR REPLACE
PROCEDURE gohan(num INT) IS
BEGIN
DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num);
END;
Unix Scripting i used
sqlplus -s... (7 Replies)
Discussion started by: gohan3376
7 Replies
6. Programming
Hi can anyone help me in
how to
1) invoke batch profile to run sqlplus on XXXXX server.
2) execute truncate table xtra.xtra_card_email_request using procedure dbadmin.truncate_table .
3) Check the count before and after the job run. (1 Reply)
Discussion started by: jakred
1 Replies
7. Shell Programming and Scripting
Hi,
How can i compile the procedure code that is there in a script file (.sql) in unix. (0 Replies)
Discussion started by: krishna_gnv
0 Replies
8. UNIX for Dummies Questions & Answers
All,
I have a 10g PL/SQL procedure that needs to be run via a unix script. How could such a script be developed.
Thanks
Aditya. (1 Reply)
Discussion started by: kingofprussia
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I am nil about UNIX and i want to learn about. For this i want to install UNIX 5.0 on my home pc. Anyone please tell me the procedure to install it. The partition and all etc. etc..
My pc configuration is
P-IV, 1.7GHz
40 GB HDD
With regards,
Phani (1 Reply)
Discussion started by: phanikmv
1 Replies
10. Shell Programming and Scripting
I am trying to execute a procedure in Unix:
Here is the deal:
I have created a procedure, which works fine,it runs via a Shell script. Now I want to execute that Procedure to it can update all the rows...
Currently have the following:
shell script:
sqlplus $ES_DB_STRING... (1 Reply)
Discussion started by: etravels
1 Replies