computer






 

Question by  Teri (27)

How do you create a windows batch files and UNIX/Linux shell scripts using an oracle function?

I am attempting to connect rman and squel.

 
+7

Answer by  worker7093 (11)

CONNECT scott/tiger SPOOL C:\emp. Lst set linesize 100 set pagesize 50 select * from emp; spool off exit; create file "c:\get_emp. bat" containing sqlplus /nolog @C:\emp. sql UNIX/Linux CONNECT scott/tiger SPOOL /u01/emp. Lst set linesize 100 set pagesize 50 select * from emp; spool off exit; create shell script"/u01/get_emp. ksh" containing #! /bin/ksh sqlplus /nolog @/u01/emp. sql

 
+2

Answer by  japratt (1687)

If you are wanting to create these types of files then you will need to open the file first. Then you will need to save the file as something different.

 
You have 50 words left!