OraFAQ Forum: Client Tools » sqlplus table output

Home » Other » Client Tools » sqlplus table output

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus table output [message #290148]

Thu, 27 December 2007 13:31

eboraks
Messages: 4
Registered: December 2007

Junior Member

Hello there, i am new to Oracle and I have been looking for a way to organized the output that I am getting from oracle.

Below is a sample of the output I am getting from select statement. I would like to know if there is any way to make it more organized?

PROJECTNO MEMBERNO PROJECTNAME
---------- ---------- ----------------------------------------
PROJECTDESC
--------------------------------------------------------------------------------
MUSICDIR
--------------------------------------------------------------------------------
PROJECTDA
---------
2000001 1000000 From where I am
Personal interpretation of classic Jazz standards
root/2000001
27-DEC-07

Thank you in advance

Report message to a moderator

Re: sqlplus table output [message #290149 is a reply to message #290148]

Thu, 27 December 2007 13:49

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you mean more organized?
Have a look at SQL*Plus parameters:
SQL*Plus� User's Guide and Reference
Chapter 12 SQL*Plus Command Reference
Section SET System Variable Summary

For instance, "set linesize" let you specify your line size.

COLUMN allows you to specify column format.

Regards
Michel

[Updated on: Thu, 27 December 2007 13:50]

Report message to a moderator

Re: sqlplus table output [message #290156 is a reply to message #290148]

Thu, 27 December 2007 17:01

eboraks
Messages: 4
Registered: December 2007

Junior Member

Thank you.

The problem got solved when I inserted the sample below into the
login.sql file.

column ColName format A10
....
....

Report message to a moderator

Re: sqlplus table output [message #290213 is a reply to message #290156]

Fri, 28 December 2007 00:25

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Into the LOGIN.SQL? You might be surprised in a month or two when another query selects data from another table with the same column name (and you'll, of course, forget what you've done yesterday).

Report message to a moderator

Re: sqlplus table output [message #290346 is a reply to message #290213]

Fri, 28 December 2007 07:28

eboraks
Messages: 4
Registered: December 2007

Junior Member

So you suggest to put in just before the SELECT statement?

Report message to a moderator

Re: sqlplus table output [message #290349 is a reply to message #290346]

Fri, 28 December 2007 07:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I think that it would be a better idea.

Or, if you decided to store a query into a file, save desired settings with it, such as

REM My query.sql

SET NUMFORMAT 999D99
SET PAGESIZE 20

COLUMN name FORMAT a8

SELECT name, ...
FROM ...

Report message to a moderator

Re: sqlplus table output [message #290351 is a reply to message #290349]

Fri, 28 December 2007 07:47

eboraks
Messages: 4
Registered: December 2007

Junior Member

Thank you for the tip.

Report message to a moderator

Previous Topic:	Difference between DEFINE and VARIABLE
Next Topic:	Tool to do syntax check on DML/DDL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 08:30:48 CST 2025