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

Advertisements

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,374 other followers


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

My Certifications






Archives

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

  • Edi Yanto: U're welcome Boss Imam :) Thanks, Edi Yanto
  • Imam: Keyen bos Edi, saya pake yg cara Worked Example II – Securing a PDF output, yg cara 1, data passwordnya dari XML Data, programnya berhasil. Trimakas
  • Edi Yanto: You're welcome Yul.... Thanks, Edi Yanto

RSS Unknown Feed

  • An error has occurred; the feed is probably down. Try again later.

Visitors

Categories

Blog Stats

  • 164,178 hits

Users Online

web counter

Pages

%d bloggers like this: