Home » SQL & PL/SQL » SQL & PL/SQL » Display column_name and column_value (Oracle 10g)
Display column_name and column_value [message #315034] Fri, 18 April 2008 13:13 Go to next message
borafaq
Messages: 5
Registered: April 2008
Junior Member
Hi,
I have a table with (A,B,C) columns and (x,y,z) values respectively. I need a display list in the following manner:

A: x
B: y
C: z

I also want the display to be dynamic i.e. if a new column is added then I want it added to the list directly without modifying the code.

Can I get some help?

Thanks in advance.
Re: Display column_name and column_value [message #315045 is a reply to message #315034] Fri, 18 April 2008 13:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See T.Kyte's print_table function.

Regards
Michel
Re: Display column_name and column_value [message #315452 is a reply to message #315045] Mon, 21 April 2008 09:25 Go to previous message
borafaq
Messages: 5
Registered: April 2008
Junior Member
Thanks it worked.
Previous Topic: Getting Log information in PL/SQL
Next Topic: query displays date in diferent formats
Goto Forum:
  


Current Time: Sun Dec 04 14:36:16 CST 2016

Total time taken to generate the page: 0.06196 seconds