RE: A quick list of formatting in SqlPlus

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 4 Nov 2004 14:34:46 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DF7E@usahm018.exmi01.exch.eds.com>

These commands are in the SQLPlus Users Guide And Reference manual Part Number A90842-01 for release 9.2

There is a chapter on writing reports using SQLPlus plus a command reference list.

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kline.Michael Sent: Thursday, November 04, 2004 2:25 PM To: oracle-l_at_freelists.org
Subject: A quick list of formatting in SqlPlus

One of our people is asking for a "cheat sheet" of formatting options in Sql*Plus.  

Is there some PDF or DOC, or something out there that gives info and format on the various options like:

Column

Set linesize, pagesize,

Ttitle, btitle

Break

Spool

Etc?  

Thanks.  

Been doing this for 20+ years, but never took the time to write any of that down. The "quick reference" used to be rather good, but it seems they neglect the formatting commands any more. Either that or they moved it.  

Michael Kline
Database Administration
SunTrust Technology Center
1030 Wilmer Avenue
Richmond, Virginia 23227
Outside 804.261.9446
STNet 643.9446

Cell 804.744.1545
 <mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com

---

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

---

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 04 2004 - 13:30:51 CST