#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    1
    Rep Power
    0

    plsql in command line


    hi all

    i'm new in oracle

    is possible to lounch plsql script from command line

    if yes please send me some example

    thanx

    Rado
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    11
    Here is what I have on my Unix box:

    Within one script, I have:
    $ORACLE_HOME/bin/sqlplus /nolog @script/script_name.sql $parameter


    and script_name.sql is:

    CONNECT user/password@DBname


    insert into tableA select * from tableB where file_name = '&1';


    DISCONNECT
    QUIT

    Regards,
    Dan

IMN logo majestic logo threadwatch logo seochat tools logo