1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Save queries to a file

Discussion in 'General' started by Pratrp1985, Jul 11, 2018.

  1. Pratrp1985

    Pratrp1985 Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    St Louis, mo
    I'm able to run queries on Oracle Express 11g but I can't figure out how to save each individual query to a file, what am I missing?
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    769
    Likes Received:
    147
    Trophy Points:
    830
    Location:
    Russian Federation
    1) sqlplus

    Code (SQL):

    spool test.txt
    SELECT dummy FROM dual;
    spool off
     
    2) UTL_FILE