Home » Developer & Programmer » Forms » rename/ format column headings
rename/ format column headings [message #84247] Thu, 19 February 2004 02:19 Go to next message
Jo
Messages: 16
Registered: September 1999
Junior Member
do you know how to rename column headings, for example, when i display customer details the column heading comes up CUST i want it to display as Customer_ID

THANX

Report message to a moderator

Re: rename/ format column headings [message #84278 is a reply to message #84247] Tue, 24 February 2004 04:35 Go to previous messageGo to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
by putting the alias name of the column like

select cust "cust_id"
from table;

Report message to a moderator

Re: rename/ format column headings [message #224823 is a reply to message #84247] Thu, 15 March 2007 10:52 Go to previous messageGo to next message
mutznutz22
Messages: 4
Registered: March 2007
Junior Member
anyone got any idea how i can do this without using an alias.

Cheers

Report message to a moderator

Re: rename/ format column headings [message #224836 is a reply to message #224823] Thu, 15 March 2007 12:02 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you've asked the question at the Forms forum, I believe it really is related to forms. If so, open this item's Property Palette and change "Prompt" property to something different (i.e. overtype 'cust' to 'Customer ID').

Report message to a moderator

Re: rename/ format column headings [message #224846 is a reply to message #84247] Thu, 15 March 2007 13:05 Go to previous messageGo to next message
nattoo
Messages: 3
Registered: March 2007
Junior Member
to change colunn heading for one session in sql*plus we have column command.

syntax:
column <col name> format a[size]|999...
column <col name> heading "new heading"


column ename heading "emp_name"

Report message to a moderator

Re: rename/ format column headings [message #224847 is a reply to message #84247] Thu, 15 March 2007 13:07 Go to previous message
nattoo
Messages: 3
Registered: March 2007
Junior Member
to rename a column name permanently we have alter table command

syntax: alter table <table name> rename <column name> to <new col name>

ex: alter table emp rename ename to emp_name


Regards

Natesh

Report message to a moderator

Previous Topic: Error in Validation
Next Topic: trigger gailure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:32:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.