DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQL commands from SHELL prompt

Threaded View

  1. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Code:
    sqlplus -s /nolog "<<"ENDSQL
    connect connectstring
    @script1.sql   or put your SQL script here.
    EXIT;
    ENDSQL

    Why don't you search in the net?

    Note: Please remove the "" from "<<"ENDSQL.
    Last edited by Thomasps; 12-29-2003 at 12:30 AM.
    Thomas Saviour([email protected])
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width