How can I issue a single command from the command line through sql plus

Question

Using SQL Plus  you can run a script with the     operator from the command line  as in   c   gt sqlplus username password databasename   c  my script sql    But is it possible to just run a single command with a similar syntax  without a whole separate script file   As in   c   gt sqlplus username password databasename  execute some procedure   I am interested in this because I want to write a batch file that simply executes a command  without generating a bunch of two-line   sql  files

User · Answer

For UNIX  AIX    export ORACLE HOME  oracleClient app oracle product version export DBUSER fooUser export DBPASSWD fooPW export DBNAME fooSchema   echo  select   from someTable      ORACLE HOME bin sqlplus  DBUSER  DBPASSWD  DBNAME

User · Answer

I m able to run an SQL query by piping it to SQL Plus    echo select count    from table    sqlplus username password database   Give   echo execute some procedure   sqlplus username password databasename   a try

User · Answer

This is how I solved the problem    lt target name  executeSQLScript  gt       lt exec executable  sqlplus  failonerror  true  errorproperty  exit status  gt           lt arg value    dbUser    dbPass   lt DBHOST gt   lt DBPORT gt   lt SID gt    gt           lt arg value     basedir  db scripttoexecute sql   gt       lt  exec gt   lt  target gt

User · Answer

Have you tried something like this   sqlplus username password database  lt   EXECUTE some proc      Seems like in UNIX you can do   sqlplus username password database  lt  lt EOF EXECUTE some proc  EXIT  EOF   But I m not sure what the windows equivalent of that would be

User · Answer

sqlplus user password sid  lt  sqlfile sql   This will also work from the DOS command line   In this case the file sqlfile sql contains the SQL you wish to execute

User · Answer

find  v      lt   0   sqlplus -s scott tiger orcl  amp  goto  eof  select sysdate from dual

[oracle] How can I issue a single command from the command line through sql plus?

Examples related to oracle

Examples related to command-line

Examples related to sqlplus