From text file to sql file

[VBVines]

I am using notepad for my editor for 8i. When I cut and paste the code to the sql prompt in sql plus the program runs fine. I want to be able to change the text file say,
test.txt to test.sql. so I can start it from the sql prompt by saying start c:\mydir\test.sql at the sql prompt. I have tried opening the notepad file going to file=>save as=> 'test.sql' and change the file type to all files.. Am I supposed to use the single quotes like I did, differently or not at all. Help aspvbwannab

 

[Guest_imported]

hi aspvbwannab,
you try using double quotes instead of single quotes.

Sudhakar

 

[rbarber]

You can run a file with an extension other than .sql if you include the extension in the start command. ie.

SQL> start c:\mydir\test.txt
or
SQL> @ c:\mydir\test.txt

rbarber@pstcc.edu