Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How Run SQL*Plus Commands That Are Stored in a Local File
How Run SQL*Plus Commands That Are Stored in a Local File? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool
✍: FYIcenter.com
If you have a group of commands that you need to run them repeatedly every day, you can save those commands in a file (called SQL script file), and using the "@fileName" command to run them in SQL*Plus. If you want to try this, create a file called \temp\input.sql with:
SELECT 'Welcome to' FROM DUAL; SELECT 'FYIcenter.com!' FROM DUAL;
Then run the "@" command in SQL*Plus as:
SQL> connect HR/retneciyf SQL> @\temp\input.sql 'WELCOMETO ---------- Welcome to 'FYICENTER.COM -------------- FYIcenter.com!
2007-04-29, 4598👍, 0💬
Popular Posts:
How To Select an Oracle System ID (SID)? - Oracle DBA FAQ - Creating New Database Instance Manually ...
What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data Data pump ...
Can we have static indexer in C# ? No.
Jack developed a program by using a Map container to hold key/value pairs. He wanted to make a chang...
How To Create an Add-to-My-Yahoo Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News ...