How Run SQL*Plus Commands That Are Stored in a Local File

Q

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

A

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, 5112👍, 0💬

How To Set Up Autotrace for a User Account
How To Set Up Autotrace for a User Account? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If an Oracle user wants to use the autotrace feature, you can use the tutorial as an example to create the required table PLAN_TABLE, the required security role PLUSTRACE, and grant the r... 2007-04-30, 6446👍, 0💬

What Is Output Spooling in SQL*Plus
What Is Output Spooling in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool The output spooling a nice feature of the command-line SQL*Plus tool. If the spooling feature is turned on, SQL*Plus will send a carbon copy of the everything on your screen to a specified local... 2007-04-29, 5865👍, 0💬

How To Generate Query Output in HTML Format
How To Generate Query Output in HTML Format? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want your query output to be generated in HTML format, you can use the "SET MARKUP HTML ON" to turn on the HTML feature. The following tutorial exercise gives you a good example: ... 2007-04-29, 5688👍, 0💬

How To Get Execution Path Reports on Query Statements
How To Get Execution Path Reports on Query Statements? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON EXPLAIN" command to turn on execution path reports on query statements. The tutorial... 2007-04-30, 5624👍, 0💬

How To Get Execution Statistics Reports on Query Statements
How To Get Execution Statistics Reports on Query Statements? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON STATISTICS" command to turn on execution statistics reports on query statement... 2007-04-30, 5416👍, 0💬

What Is Oracle Server Autotrace
What Is Oracle Server Autotrace? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Autotrace is Oracle server feature that generates two statement execution reports very useful for performance tuning: Statement execution path - Shows you the execution loop logic of a DML statement... 2007-04-29, 5391👍, 0💬

How To Revise and Re-Run the Last SQL Command
How To Revise and Re-Run the Last SQL Command? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If executed a long SQL statement, found a mistake in the statement, and you don't want enter that long statement again, you can use the input buffer commands to the correct last statem... 2007-04-29, 5131👍, 0💬

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 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" co... 2007-04-29, 5113👍, 0💬

What Is Input Buffer in SQL*Plus
What Is Input Buffer in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Input buffer is a nice feature of the command-line SQL*Plus tool. It allows you to revise a multiple-line command and re-run it with a couple of simple commands. By default, input buffer is always ... 2007-04-29, 5073👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.