HOW TO EXECUTE A SCRIPT WHICH IS IN AN NOTEPAR EDITOR

[MURALI KRISHNA]

I have saved the sql script in the notepad i was trying to execute that like
start C:\TEST\TEST.TXT;

@ C:\TEST\TEST.TXT; similar to sql prompt

both are shows error ora-00900 invalid sql statement

why? it shows error

thanks in advance

 

[Marco Kalter]

I assume you are using the SQL Window? It can only execute SQL and PL/SQL commands.

For SQL*Plus compatibility, including the @ command, you can use the Command Window instead.

 

[MURALI KRISHNA]

thank you Marco Kalter for your answer