A little SQL help

[Chuckie]

It's been a little while since I used SQL and I forgot the command that allows you to run a text file with SQL script in it from a Desktop of pc, while using Oracle's SQL Plus.

Can anyone recommend any good online SQL resources ?


Chuck

[vgarcia]

http://www.w3schools.com
Click on "Learn SQL" on the top left menu.

--Vinnie

[CrazyCrane]

To use a script contained in an external file called filename.sql in SQLPlus, I think you just do:

> filename.sql

(i.e. greater-than followed by the name of the file).

[JEmLAC]

(from the Oracle 8i Complete Reference - Loney & Koch, Chapter 6, p 99)

start Tells SQLPLUS to follow (execute) the instructions you've saved in a file.

I tried saving a simple SQL select statement into text file and storing it on my hard drive. At the SQLPLUS prompt I typed

start d:\test.sql

and the statement ran. I assume it will do the same for more complex scripts.

[Chuckie]

Originally posted by JEmLAC
(from the Oracle 8i Complete Reference - Loney & Koch, Chapter 6, p 99)

start Tells SQLPLUS to follow (execute) the instructions you've saved in a file.

I tried saving a simple SQL select statement into text file and storing it on my hard drive. At the SQLPLUS prompt I typed

start d:\test.sql

and the statement ran. I assume it will do the same for more complex scripts.

Thats exactly what I was looking for ..

Thanks

Chuck