How to see different types of columns in Oracle SQL Developer

Question

Let's say that a table has several types of subclasses. How can I see all columns from different types in sqldeveloper? Only common columns can be seen in the table view. Thank.

Answer 1

This is not possible in SQL Developer, as it currently stands (since 1.5.4).

By the way, this is not possible in SQL * PLUS. The setup DESCRIBE DEPTH 2simply shows more details about the super type:

SQL> desc my_people
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------
 CREATE_DATE                               NOT NULL DATE
 ID                                        NOT NULL NUMBER
 DETAILS                                            PERSON

SQL> set describe depth 2
SQL> desc my_people
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------
 CREATE_DATE                               NOT NULL DATE
 ID                                        NOT NULL NUMBER
 DETAILS                                            PERSON
 PERSON is NOT FINAL
   NAME                                             VARCHAR2(30 CHAR)

SQL> 

(I checked. set describe depth 3Does nothing, what it controls is an extension of the types used as attributes of the mapped types.)

, , . , - . Oracle , - .

, SQL Developer , , . ....