SQL & PL/SQL

I have a column that will only hold 1 character. This is good, but I want the Column width to match the column header.

For example,

Currently I get:

select * from table;

I NAME
- ---------
1 ROBERT

The problem is, I want the Column header spelled out (in this case it's just ID)

ID NAME
-- ---------
1 ROBERT

Better Yet,

if i did:

select ID "ID NUMBER", NAME "FIRST NAME" from table;

I'd like to see:

ID NUMBER FIRST NAME
--------------- -----------------
1 ROBERT

(Centering the ID within the Column width would be good too, but that is "gravy")

Any thoughts? I've been trying:

COLUMN ID FORMAT A10 (which obviously didn't work!)

Thanks,

KSL.

Edited by: leonhardtk on Aug 23, 2010 11:55 AM