Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: What is the SQL cmd for reading in a script?
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
![]() |
![]() |