Run sql statement through batch file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sandeep1234
    New Member
    • Jan 2008
    • 7

    Run sql statement through batch file

    I want to run the sql statement through batch processing file
    so if any one know how to connect to oracle and run a sql statement
    then please tell me
    Thank you
    sandeep kumar pradhan
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Originally posted by sandeep1234
    I want to run the sql statement through batch processing file
    so if any one know how to connect to oracle and run a sql statement
    then please tell me
    Thank you
    sandeep kumar pradhan
    By batch processing file do you mean a Windows .bat file?
    If so, you can put the sql statements in a .sql file and then write a bat file that connects to SQL *Plus and executes them. The execution will be as simple as calling
    Code:
    START file.sql;

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      you need to write all the connection and sql code to a batch file
      end the commands by semicolon
      call the batch file .

      Comment

      Working...