Home » SQL & PL/SQL » SQL & PL/SQL » sql*plus commands
sql*plus commands [message #211845] Tue, 02 January 2007 11:49 Go to next message
durai
Messages: 38
Registered: December 2006
Member
select * from emp_table;
it show the output as below
EMP_CODE EMP_NAME DESIG HEAD DOJ
--------- ----------- --------- ---- -----
BASIC DEP_CODE
--------- ----------

i want the column to be in same row so i tried
column dep_code format a20;
but it make the value as ######(by what means i can undo this)
also give me some more ideas on sql*plus commands
Re: sql*plus commands [message #211846 is a reply to message #211845] Tue, 02 January 2007 11:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> but it make the value as ######
Might be because it is defined as number and your formatting as charcater.
>>also give me some more ideas on sql*plus commands
How about some documentation?
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a90842/toc.htm
Re: sql*plus commands [message #211848 is a reply to message #211846] Tue, 02 January 2007 11:57 Go to previous messageGo to next message
durai
Messages: 38
Registered: December 2006
Member
yeah u r right it's datatype is number what shall i do now
Re: sql*plus commands [message #211849 is a reply to message #211848] Tue, 02 January 2007 12:07 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If you still want to format the column, then use
--use the desired value
sql> column dep_code format 999
or
just increase the default linesize
-- use the desired value
sql> set linesize 120 
Previous Topic: Min date value in the future, how can I do it??
Next Topic: Creation of multiple temp tables
Goto Forum:
  


Current Time: Fri Dec 02 16:51:58 CST 2016

Total time taken to generate the page: 0.22024 seconds