PREV INDEX NEXT    SLUUG HOME

SQL in KSH
Running SQL Scripts in Kornshell

The Basics (2)

BASIC SYNTAX USING SQLPLUS


    sqlplus -s <<!  # inline script
    select sysdate from dual;
    !
    
    sqlplus -s <<!  # separate SQL script
    @ myscript.sql
    !
    
    sqlplus -s <<!  # executing PL/SQL script
    exec plsqlfile;
    !

SIMILAR USES


    mail -s "my subject line" spammed@my.org <<!
    lines of my message
    !

    ftp -n -i -v ftpsite <<! 
    user myuserid mypassword
    cd /some/directory/there
    get thefileiwant
    bye
    !
2002 April 10
Tom Chapin -- 314-721-3581 -- tjc@mvp.net