How do you run a PL/SQL script in SQL Plus

[L Brennan]

Hi,
I think this is an easy one for anyone who use PL?SQL regularly, but could anyone tell me how to run an actual script. I have my script saved off in a .sql file on my C: drive. I have a SQL*Plus connection, but I seriously don't know how to kick the actual script off. I've tried copying and pasting it into the SQL*Plus session but to no avail.
Any help would be greatly appreciated. Apologies if this is a really silly question, but I have been looking on the web and I can find any info on kicking the script off.
Thanks!
L

[Mark Spritzler]

You preced the file name with the "@" symbol.
like

@my_script.sql
Now where you fire off SQLPlus determines which directory you are in. So If on a command line you are in c:\myfolder but your script is in the root of c, c:\ then the above will not work because you need to specify path with the call as in.
@c:\my_script.sql
Mark

[L Brennan]

Thats great mark. Thanks a mill!