Home » SQL & PL/SQL » SQL & PL/SQL » column format
column format [message #308420] Mon, 24 March 2008 04:52 Go to next message
ramya29p
Messages: 146
Registered: November 2007
Location: Chennai
Senior Member
Hi,
can anyone tell me what is the use of
COLUMN column_name OFF

Re: column format [message #308421 is a reply to message #308420] Mon, 24 March 2008 04:54 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It removes previous column formatting.
SQL> column sal format 999,990.00
SQL> select sal from emp where rownum = 1;

        SAL
-----------
     800.00

SQL> column sal off;
SQL> select sal from emp where rownum = 1;

       SAL
----------
       800

SQL>
Re: column format [message #308423 is a reply to message #308420] Mon, 24 March 2008 04:56 Go to previous message
Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12013.htm#i2697128

Quote:
ON | OFF
Controls the status of display attributes for a column. OFF disables the attributes for a column without affecting the attributes' definition. ON reinstates the attributes.

Regards
Michel
Previous Topic: Update Query
Next Topic: complex procedure to count spaces
Goto Forum:
  


Current Time: Wed Feb 12 08:55:17 CST 2025