Edi Yanto (何 萬 新)

Customized the Column Heading in Oracle

Posted on: April 17, 2007


In Oracle, we can customize the column heading and formatted it’s value.

Controls display of a column:

COL[UMN] [ { column|alias } [option] ]

  • CLE[AR] : Clears any column formats
  • HEA[DING] text : Sets the column heading
  • FOR[MAT] format : Changes the display of the column using a format model
  • NOPRINT | PRINT
  • NULL

 

  • Create Column Headings

COLUMN ename HEADING ‘Employee Name’
COLUMN sal JUSTIFY LEFT FORMAT $99,990.00
COLUMN mgr FORMAT 999999 NULL ‘No Manager’

  •  Display the current setting for the ename column

COLUMN ename

  • Clear settings for the ename column

COLUMN ename CLEAR

Example:
Customized the SAL column heading and formatted salary values using a COLUMN command option.
column_heading.jpg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,368 other followers


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn

My Certifications






Follow me on Twitter

Archives

April 2007
M T W T F S S
« Mar   May »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Visitors

Categories

Blog Stats

  • 140,585 hits

Users Online

web counter

Pages

%d bloggers like this: