Re: What is the SQL cmd for reading in a script?

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 2000/07/10
Message-ID: <396a1a97@news.victoria.tc.ca>#1/1

Sean (dolans_at_my-deja.com) wrote:
: When you want to run a script (say PUPBLD.SQL) which is on your local
: harddrive, what is the SQL command for loading that script through SQL
: Plus? I have looked through the reference materials and can not find
: any information.

: Thanks,
: Sean

SQL> @your-file-name-complete-with-path.SQL

(note the @).

also check out RUN

also check out SQLPATH. Its an environment variable that tells SQLPLUS where to look for SQL scripts so you don't have to enter the path to the script. You set it ahead of time, its similar to the regular PATH environment variable but used by SQLPLUS. Received on Mon Jul 10 2000 - 00:00:00 CDT