SQL Plus

From TekiWiki

Jump to: navigation, search

This whole wiki has now moved to http://www.springboardsolutions.com/wiki

Go to this page SQL Plus

Line 1: Line 1:
-
SQL Plus is the [[Oracle Database]]'s supplied interactive SQL client. In later versions of Oracle, for interactive SQL queries, SQL Developer is a better GUI. However, to run scripts and run SQL as part of batch scripts, SQL Plus is your man.
+
SQL*Plus is the [[Oracle Database]]'s supplied interactive SQL client. In later versions of Oracle, for interactive SQL queries, SQL Developer has a better GUI. However, to run scripts and run SQL as part of batch scripts, SQL Plus is your man.
==Setting Up SQL Plus==
==Setting Up SQL Plus==
Line 43: Line 43:
===Editing Your SQL===
===Editing Your SQL===
-
Use your favourite text editor to edit files - for instance - TextPad - by altering the Sql*Plus system variable:
+
Use your favourite text editor to edit files - for instance - TextPad - by altering the SQL Plus system variable:
<pre>
<pre>

Revision as of 01:13, 11 December 2011

Personal tools