Exforsys.com
 
Home Tutorials Oracle 9i
 

Tutorial 2: SQL *Plus Commands

 

Using SQL *Plus for Storing Temporary Values

Page 4 of 4


Using SQL *Plus for Storing Temporary Values

Substitution variables can replace SQL*Plus command options or other hard-coded text. They can be used to customize SQL*Plus script output. Substitution variable references in a statement are pre-processed and replaced before SQL*Plus executes the statement. Variable values can be hard coded, prompted for, or set to script parameters. Variables can also hold values returned from queries. Sometimes substitution variables are known as user variables or define variables.


Bind variables store data values for SQL and PL/SQL statements executed in the RDBMS. They can hold single values or complete result sets.


System variables contain values directly controlling SQL*Plus, such as the line size and page size of reports. Some system variables affect how substitution variables are processed. System variables are sometimes called SET variables.


Click Here to read the Notes




First Page: Tutorial 2: SQL *Plus Commands


Read Next: Tutorial 3 : Restricting and Sorting Data



 

 

Comments


Iceman said:

  hi i view the solution and output files it says

"Forbidden
You don't have permission to access /developers/articles/sqlplus_output1.html on this server."
December 23, 2008, 9:00 am

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape