Re: SQLPLUS command line


<snarks@xxxxxxxxx> a écrit dans le message de news: 1150724669.757425.13660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| I'm running SQL script filess through SQLPLUS (Windows platform), but I
| want to make sure that SQLPLUS terminates and doesn't sit there waiting
| for a QUIT command. How can I do this? I would have thought that it
| would have a command line parameter to force this, I don't want to have
| to remember to put QUIT at the end of every sql script that I or my
| colleagues write.
|
| Phil Hibbs.
|

you can use:

type script.sql | sqlplus ...

instead of:

sqlplus ... @script.sql

Just a small workaround.

Regards
Michel Cadot


.

Relevant Pages

  • Re: Spool To Datestamped File - Newbie Question
    ... have a simple sql script, say db_query.sql, which runs a select against one ... How do I write a unix script which will kick off ... When you say "datestamped" I'm guessing you mean the datestamp is part ... This will redirect what sqlplus sends to the standard output into the ...
    (comp.unix.programmer)
  • script that run a sql script
    ... I'm trying to write a shell script that does followings. ... login into sqlplus ... run a sql script in the current directory. ... exit from sqlplus ...
    (comp.unix.shell)
  • Question with DBI versus PERL
    ... I have a really big sql scripts with many select, procedures and spool spool ... I want to know how can i run this sql script with DBI. ... With sqlplus, ... this script with perl. ...
    (perl.dbi.users)
  • SQLPLUS command line
    ... I'm running SQL script filess through SQLPLUS, ... want to make sure that SQLPLUS terminates and doesn't sit there waiting ... for a QUIT command. ...
    (comp.databases.oracle.tools)