OraFAQ Forum: SQL & PL/SQL » Formatting result of select query

Home » SQL & PL/SQL » SQL & PL/SQL » Formatting result of select query

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

Formatting result of select query [message #9989]

Thu, 18 December 2003 23:38

John varghese
Messages: 1
Registered: December 2003

Junior Member

Hi,
on firing the query
"select * from user_master;" on the sql prompt
the display is not very organized.
It is something like this:

USERID USERNAME T FACTORYCOD GRADE
---------- ---------------------------------------- - ---------- -----
PWD PSWEXPDAT EMAILID
--------------- --------- --------------------------------------------------
LOGINCREA VENDORCODE USERDISABLED AUTHENTICATED RECEIVEACK LASTLOGGE ROLEID
--------- ---------- ------------ ------------- ---------- --------- ----------
PERMISSION
--------------------------------------------------------------------------------
DIVISIONCODE
-------------------------
e55 hhjbjb C f123
rr 22-DEC-03 hh@cg.com
19-DEC-03 0 0 0 19-DEC-03 1

USERID USERNAME T FACTORYCOD GRADE
---------- ---------------------------------------- - ---------- -----
PWD PSWEXPDAT EMAILID
--------------- --------- --------------------------------------------------
LOGINCREA VENDORCODE USERDISABLED AUTHENTICATED RECEIVEACK LASTLOGGE ROLEID
--------- ---------- ------------ ------------- ---------- --------- ----------
PERMISSION
--------------------------------------------------------------------------------
DIVISIONCODE
-------------------------
abc
S1

Can we format it somehow?

Thanks

Report message to a moderator