Easy one: how to execute SQL scripts in MS-DOS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Easy one: how to execute SQL scripts in MS-DOS

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    42

    Question

    Hi!

    When I want to execute an SQL script in Unix, I do this:
    sqlplus user/passwd @/foo/file.sql > /doo/myfile.out

    Then, I've got my outfile to examine.

    But I am not able to do the same at MS-DOS (Windows).
    Wich is the rightest method?

    Best regards and thanks.
    ========
    LARRY ELLISON

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    you can do exactly the same thing ...

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    what's the problem?

    Code:
    C:\scripts>type user.sql
    select username from dba_users;
    exit
    
    C:\scripts>sqlplus system/manager @user.sql > user.out
    
    C:\scripts>type user.out
    
    SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 13 08:59:25 2001
    
    (c) Copyright 2000 Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production
    
    
    USERNAME
    ------------------------------
    SYS
    SYSTEM
    OUTLN
    DBSNMP
    JEFFHPC
    OPS$JEFFHPC
    JEFFH
    USERA
    USERB
    
    9 rows selected.
    
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production
    
    C:\scripts>
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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