🚀 go-pugleaf

Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool
http://dba.fyicenter.com/faq/oracle/oracle_introduction_to_command_line_sqlplus.html

A collection of 25 FAQs on Oracle command-line SQL*Plus client tool.
Clear answers are provided with tutorial exercises on creating
tnsnames.ora and connecting to Oracle servers; SQL*Plus settings and
environment variables; saving query output to files; getting query
performance reports. Topics included in this FAQ are:

What Is SQL*Plus?
How To Start the Command-Line SQL*Plus?
How To Get Help at the SQL Prompt?
What Information Is Needed to Connect SQL*Plus an Oracle Server?
What Is a Connect Identifier?
How To Connect a SQL*Plus Session to an Oracle Server?
What Happens If You Use a Wrong Connect Identifier?
What To Do If DBA Lost the SYSTEM Password?
What Types of Commands Can Be Executed in SQL*Plus?
How To Run SQL Commands in SQL*Plus?
How To Run PL/SQL Statements in SQL*Plus?
How To Change SQL*Plus System Settings?
How To Look at the Current SQL*Plus System Settings?
What Are SQL*Plus Environment Variables?
How To Generate Query Output in HTML Format?
What Is Output Spooling in SQL*Plus?
How To Save Query Output to a Local File?
What Is Input Buffer in SQL*Plus?
How To Revise and Re-Run the Last SQL Command?
How Run SQL*Plus Commands That Are Stored in a Local File?
How To Use SQL*Plus Built-in Timers?
What Is Oracle Server Autotrace?
How To Set Up Autotrace for a User Account?
How To Get Execution Path Reports on Query Statements?
How To Get Execution Statistics Reports on Query Statements?

Please visit this Website.:
http://dba.fyicenter.com/faq/oracle/oracle_introduction_to_command_line_sqlplus.html

TThank you,
Team DBAFYI - DBA Resource Center
http://dba.fyicenter.com