1 2 >   Sort: Rank

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, 4537👍, 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, 4737👍, 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, 4861👍, 0💬

How To Use SQL*Plus Built-in Timers
How To Use SQL*Plus Built-in Timers? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you don't have a stopwatch/timer and want to measure elapsed periods of time, you can SQL*Plus Built-in Timers with the following commands: TIMING - Displays number of timers. TIMING START [n...
2007-04-29, 4153👍, 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, 4392👍, 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, 4231👍, 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, 4196👍, 0💬

How To Save Query Output to a Local File
How To Save Query Output to a Local File? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Normally, when you run a SELECT statement in SQL*Plus, the output will be displayed on your screen. If you want the output to be saved to local file, you can use the "SPOOL fileName" comman...
2007-04-29, 5572👍, 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, 4223👍, 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, 4696👍, 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, 4919👍, 0💬

How To Look at the Current SQL*Plus System Settings
How To Look at the Current SQL*Plus System Settings? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to see the current values of SQL*Plus system settings, you can use the SHOW command as shown in the following tutorial exercise: SQL> SHOW AUTOCOMMIT autocommit OFF S...
2007-04-29, 4173👍, 0💬

What Are SQL*Plus Environment Variables
What Are SQL*Plus Environment Variables? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Behaviors of SQL*Plus are also controlled a some environment variables predefined on the local operating system. Here are some commonly used SQL*Plus environment variables: ORACLE_HOME - The...
2007-04-29, 4302👍, 0💬

How To Change SQL*Plus System Settings
How To Change SQL*Plus System Settings? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list: SET AUTOCOMMIT OFF - Turns off the auto...
2007-04-29, 4233👍, 0💬

How To Run PL/SQL Statements in SQL*Plus
How To Run PL/SQL Statements in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example: SQL> SET SERVEROUTPUT ON SQL> EXECUTE DBMS_OUTPUT.P...
2007-04-29, 4292👍, 0💬

What Types of Commands Can Be Executed in SQL*Plus
What Types of Commands Can Be Executed in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool There are 4 types of commands you can run at the SQL*Plus command line prompt: 1. SQL commands - Standard SQL statements to be executed on target database on the Oracle server. Fo...
2007-04-29, 4176👍, 0💬

How To Run SQL Commands in SQL*Plus
How To Run SQL Commands in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example: SQL> SELECT 'Welco...
2007-04-29, 4273👍, 0💬

What Happens If You Use a Wrong Connect Identifier
What Happens If You Use a Wrong Connect Identifier? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL> CONNECT fyi/retneciyf@WRONG; ...
2007-04-28, 4515👍, 0💬

What To Do If DBA Lost the SYSTEM Password
What To Do If DBA Lost the SYSTEM Password? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If the DBA lost the password of the SYSTEM user account, he/she can go to the Oracle server machine, and run SQL*Plus on server locally with the operating system authentication method to ...
2007-04-28, 4417👍, 0💬

How To Connect a SQL*Plus Session to an Oracle Server
How To Connect a SQL*Plus Session to an Oracle Server? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new "connect identifier" c...
2007-04-28, 4294👍, 0💬

What Is a Connect Identifier
What Is a Connect Identifier? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool A "connect identifier" is an identification string of a single set of connection information to a specific target database instance on a specific Oracle server. Connect identifiers are defined and stor...
2007-04-28, 4871👍, 0💬

What Information Is Needed to Connect SQL*Plus an Oracle Server
What Information Is Needed to Connect SQL*Plus an Oracle Server? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you want to connect your SQL*Plus session to an Oracle server, you need to know the following information about this server: The network hostname, or IP address, o...
2007-04-28, 8741👍, 0💬

How To Get Help at the SQL Prompt
How To Get Help at the SQL Prompt? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Once SQL*Plus is started, you will get a SQL prompt like this: SQL>. This where you can enter commands for SQL*Plus to run. To get help information at the SQL prompt, you can use the HELP c...
2007-04-28, 4231👍, 0💬

How To Start the Command-Line SQL*Plus
How To Start the Command-Line SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If you Oracle server or client installed on your windows system, you can start the command-line SQL*Plus in two ways: 1. Click Start > All Programs > Oracle ... > Start SQL Command Line. The ...
2007-04-28, 4314👍, 0💬

1 2 >   Sort: Rank