OraFAQ Forum: SQL & PL/SQL » Sql Query to list tablenames and column

Home » SQL & PL/SQL » SQL & PL/SQL » Sql Query to list tablenames and column_names.

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

Sql Query to list tablenames and column_names. [message #1498]

Mon, 06 May 2002 21:16

karunamoorthy_p
Messages: 13
Registered: April 2002

Junior Member

Could you please help me to solve the following query.

I have following sample tables viz.

1. bonus table
(ename,job,sal,comm).

2. dept table
(deptno,dname,loc)

3. emp table
(empno,ename,job,mgr,hiredate,sal,comm,deptno)

My output required is like this:-
--------------------------------

TABLENAME COLUMN_NAME
--------- -----------
bonus ename
bonus job
bonus sal
bonus comm
dept deptno
dept dname
dept loc
emp empno
emp ename
emp job
emp mgr
emp hiredate
emp sal
emp comm
emp deptno

How to get the above result using simple sql query.
(ie. both tablename and the corresponding column_names).

Please help.

Report message to a moderator

Re: Sql Query to list tablenames and column_names. [message #1501 is a reply to message #1498]

Mon, 06 May 2002 22:59

srn
Messages: 1
Registered: May 2002

Junior Member

select a.table_name,b.column-name from all_tables a, all-tab_columns b where a.table-name = b.table_name

Report message to a moderator

Re: Sql Query to list tablenames and column_names. [message #1503 is a reply to message #1498]

Tue, 07 May 2002 05:28

Christine Pollhaus
Messages: 18
Registered: May 2002

Junior Member

Hi, try the Data Dictionary table named USER_TAB_COLUMNS like

select table_name, column_name from user_tab_columns where table_name = 'bonus' or table_name = 'dept' or table_name = 'emp';

hope it helps, good luck

Report message to a moderator

Re: Sql Query to list tablenames and column_names. [message #1691 is a reply to message #1498]

Thu, 23 May 2002 00:00

M.P.KIRAN KUMAR
Messages: 9
Registered: May 2002

Junior Member

hi,

u can get the result by using USER_TAB_COLUMS.

bye

Report message to a moderator

Previous Topic:	Stored Procedure Tuning.
Next Topic:	datatypes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 15:55:54 CDT 2024