Answer Detail: RE: dear friendi want to know that in a t...

GeekInterview.com > Interview Questions > Oracle > General

Print |

Question: dear friend

i want to know that in a table how to change the column to row.

October 10, 2006 21:46:06	#1
Kyle	Member Since: Visitor Total Comments: N/A
RE: dear friendi want to know that in a t...
there is already a table with all the column names for a table in rows. user_tab_cols.select table_name, column_name from user_tab_cols where table_name = 'your table';It should give you the result you want.