Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Unanswered: connecting to a database and running a query file

    I know the command to connect to a database in unix shell script is like this
    sqlplus @USERNAME/@PASSWORD @HOSTNAME however I don't know how to get the query file to run, can anyone help me out with this?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Actually if it's oracle database, it should be like this:
    Code:
    sqlplus USERNAME/PASSWORD@DBNAME @MYQUERY.sql


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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