Re: Sample Script?

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Thu, 20 Dec 2007 15:48:14 GMT
Message-ID: <29waj.8936$wy2.7638@edtnps90>

"AP" <megacrosstab_at_greenixsolutions.com> wrote in message news:804a246f-3fca-4b54-a2bc-aeecac1841eb_at_j20g2000hsi.googlegroups.com...
> Hello I am new to Oracle. What I am trying to do is basic, I think. I
> typically use toad to run select statements. I want to be able to
> create a script that simply when executed, runs the select statement
> and exports it to a file. Once I get this figured out, I would use a
> command line method to run it on a scheduled basis. Any samples ?
>
> Thanks

In its most basic form:

sqlplus userid/passwd_at_dbname @yourscript.sql

with a spool statement in the yourscript.sql file.

Hardcoding passwords obviously is not very good. There are ways of redirecting input from another file into your script.

-- 
Terry Dykstra

Received on Thu Dec 20 2007 - 09:48:14 CST