SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find the default columns names

907442Dec 14 2012 — edited Aug 22 2013

Hi Dev's,

Here is my sample table. how to find the list of default column names list.

CREATE TABLE temp_tab
(
a1 VARCHAR2(20),
a2 NUMBER NOT NULL,
a3 VARCHAR2(30) default 'ram',
a4 NUMBER ,
a5 NUMBER default 4
);

my output should be :
a3,a5 columns.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2013

Added on Dec 14 2012

4 comments

317 views