OraFAQ Forum: SQL & PL/SQL » How to display Column name

Home » SQL & PL/SQL » SQL & PL/SQL » How to display Column name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to display Column name [message #7695]

Tue, 01 July 2003 12:25

MM
Messages: 27
Registered: July 2002

Junior Member

I have a requirement which needs to display column name before the value of the column.

Example
Column name is MESSAGE_GROUP
Value in the column is BVTM

I need to be displayed as

MESSAGE_GROUP=BVTM in the MESSAGE_GROUP column

Thanks in advance.

MM

Report message to a moderator

Re: How to display Column name [message #7697 is a reply to message #7695]

Tue, 01 July 2003 12:50

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select message_group || ' in the MESSAGE_GROUP column' message_group
  from table_name;

Report message to a moderator

Re: How to display Column name [message #7700 is a reply to message #7697]

Tue, 01 July 2003 13:21

MM
Messages: 27
Registered: July 2002

Junior Member

When i run the query as explained by you, the result set is
BVTM in the MESSAGE_GROUP column
Is is possible to display
MESSAGE_GROUP = BVTM

Thanks
MM

Report message to a moderator

Re: How to display Column name [message #7703 is a reply to message #7700]

Tue, 01 July 2003 14:29

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

Just change the wording between the single quotes and reverse the concatenation:

SELECT 'MESSAGE_GROUP = ' || message_group
AS message_group
FROM table_name;

Report message to a moderator

Re: How to display Column name [message #7704 is a reply to message #7703]

Tue, 01 July 2003 15:46

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Sorry, I misread that - I thought they wanted the text to be everything to the right of the equals sign.

Report message to a moderator

Previous Topic:	best WHERE clause
Next Topic:	SQLPlus PL/SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 06:43:49 CDT 2024