nobleit
asked on
output
How can we see the output in a nicer way
I mean the alignment..the display
it is a broken view now..
SQL> select creation_time,name from v$datafile;
CREATION_
---------
NAME
--------------------------
14-JUN-11
/u01/app/oracle/oradata/db
14-JUN-11
/u01/app/oracle/oradata/db
14-JUN-11
/u01/app/oracle/oradata/db
3 rows selected.
SQL>
I mean the alignment..the display
it is a broken view now..
SQL> select creation_time,name from v$datafile;
CREATION_
---------
NAME
--------------------------
14-JUN-11
/u01/app/oracle/oradata/db
14-JUN-11
/u01/app/oracle/oradata/db
14-JUN-11
/u01/app/oracle/oradata/db
3 rows selected.
SQL>
You can also set individual column lengths if columns wrap. Check out the column command (col for short).
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
also, you might want format your creation_times to get the time information
select to_char(creation_time,'yyy
select to_char(creation_time,'yyy
ASKER
perfect..thanks
No split? That is basically what I posted.
Set linesize 256
Or some number large enough to hold the entire line.
Refer to the sqlplus docs for all the formatting options you have.