Hi,

You can see the description of a type with the command:
DESC YOUR_TYPE_NAME;

If you want to see the description of a table containing the user
defined types then...

First connect to sqlplus and see the results of the command:
show describe;

The result should be something like:
DEPTH 1 LINENUM OFF INDENT ON

If the DEPTH is 1 then, set the DEPTH to a desired level like 2,3..n
(n<=50) by the command:
set describe depth n LINENUM OFF INDENT ON;

Now to see the description of the table as well as the types in it, you
can put the command:
DESC table_name;



Thanks & Regards,

Manash Partim Baruah
Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com


-----Original Message-----
From: thusharchandran.c
[mailto:oracledba-ezmlmshield-x3092051.[Email address protected]
Sent: Wednesday, November 28, 2007 3:20 PM
To: LazyDBA Discussion
Subject: how can take the rows in nested table

Send me the query to retrieve the data from nested
table.
And how I can see the description of the object type Thenks

Renu.k





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page