Re: How to list tables or views? (Beginner)

From: Tim Shute <Tshute_at_nisoft.co.uk>
Date: Tue, 3 Nov 1998 12:40:43 +0000
Message-ID: <z2WvtFALnvP2IAld@nisoft.demon.co.uk>

In article <363EABFB.5C89F388_at_email.mot.com>, Zhang LinZai <fchn088_at_email.mot.com> writes
>Please advise how to list tables or views in Oracle?
>
>--
>best regards,
>Zhang LinZai
>
>Email: fchn088_at_email.mot.com
>
>

I'm not sure if I understand you correctly but there are (at least) three possible answers :-
1. To show to data structure of a table or view

DESC OBJECT_NAME; 2. To show the actual data (assuming that the datatypes and sizes of the columns allows it)

SELECT * FROM OBJECT_NAME; 3. To show all the tables and views owned by a user

SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_TYPE IN('TABLE', 'VIEW'); 4. Read a manual, do a course ;-)

HTH
--
Tim Shute
Software Engineering Manager

NiSoft (UK) Limited
Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH Tel: +44 (0) 1232 814121, Fax: +44 (0) 1232 813962 email: tshute_at_nisoft.co.uk
Internet: www.nisoft.co.uk Received on Tue Nov 03 1998 - 06:40:43 CST