Search Results

Thanks for reply. But I want to do it without adding 'order By' in Query. Is there any way to do it.

Hello,

I have a shell script through which I am executing .sql file and spooling the result of Query from .sql . I want to spool the result in ascending order. Is there any parameter to be set...

Thanks Durden. My problem is resolved.
Thanks everyone for your valuable inputs.

If I take procedure code and execute on Toad, procedure is getting created successfully with no errors. I want this (to create procedure) through Unix.

Thanks for your reply.

i have below unix code to connect to DB :

/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/sqlplus -s darwin_ext@SRCDBCA/Da3w1n\#E5t << EOF
@proc.sql


proc.sql...

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