Home » SQL & PL/SQL » SQL & PL/SQL » executing a .sqlplus
executing a .sqlplus [message #184723] Thu, 27 July 2006 10:10 Go to next message
Messages: 202
Registered: April 2006
Senior Member
I have a .sqlplus file .How can I execute this file?
Re: executing a .sqlplus [message #184736 is a reply to message #184723] Thu, 27 July 2006 11:33 Go to previous message
Messages: 21122
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
From the OS command prompt, run something like

OS> SQLPLUS username/password@database @file.sql

Or, while in SQL*Plus, use

SQL> @file.sql
SQL> RUN file.sql
Previous Topic: how to get rid of full table scan
Next Topic: Passing XML as a parameter to a stored procedure
Goto Forum:

Current Time: Sat Jun 24 19:29:22 CDT 2017

Total time taken to generate the page: 0.10096 seconds