I am trying to execute a script file in sql*plus from the command line
rather than opening SQL*PLUS and then executing the script. Can anyone
want to be prompted for them??
Thanks in advance!
Lisa
by Lisa M. Lewi » Wed, 04 Jun 1997 04:00:00
I am trying to execute a script file in sql*plus from the command line
rather than opening SQL*PLUS and then executing the script. Can anyone
want to be prompted for them??
Thanks in advance!
Lisa
by Bill Kannaw » Wed, 04 Jun 1997 04:00:00
you can place username/password in the script such as...
Myname/mypassword
|> I am trying to execute a script file in sql*plus from the command line
|> rather than opening SQL*PLUS and then executing the script. Can anyone
|> tell me the syntax? I am doing something like: sqlplus
|> want to be prompted for them??
|>
|> Thanks in advance!
|>
|> Lisa
|>
--
Technical Information Processing System |
US Office of Surface Mining; 1999 Broadway, |
Suite 3320, Denver, Colorado 80202 |
by Konstantin V Sartako » Thu, 05 Jun 1997 04:00:00
> I am trying to execute a script file in sql*plus from the command line
> rather than opening SQL*PLUS and then executing the script. Can anyone
> tell me the syntax? I am doing something like: sqlplus
> want to be prompted for them??
Regards
-------------------------------
Konstantin V. Sartakov
Kuzbassprombank
Kemerovo
Russia
1. File Extension in SQL*PLus Script
I am running a SQL*Plus script, which outputs an HTML-Formatted file.
I can get it to create a .html extension in UNIX, but not NT. Can
someone tell me what I need to do to effect this?
This is 8.1.7.
COLUMN A1 NOPRINT NEW_VALUE DATO;
SELECT TO_CHAR(SYSDATE - 1,'MMDDYY') A1 FROM DUAL;
SPOOL x:&DATO\.html -- Escape works in Unix, but not NT
2. Dynamic Query Generation in Stored Procedures / Database Switching
3. How to Call a SQL Script file from another SQL Script File
4. How different is Analysis Services from OLAP Services?
5. Passing param from BAT file to SQL script
6. Question: DBase Libraries for C++
7. The case preference of writing SQL, PL/SQL, SQL*PLUS comands/scripts
8. Step from access to SQL Server
9. Passing value from a PL/SQL variable to a SQL*Plus variable
10. Oracle 7.3: problem running SQL script with SQL*Plus
11. How to call file(script1.sql) from inside the script (script.sql)
12. Oracle*&SQL*Plus 8.0/Net8 versus Designer&SQL*Plus 3.x/SQL*Net
13. passing params to script files