OraFAQ Forum: SQL & PL/SQL » Constraints in Describe

Home » SQL & PL/SQL » SQL & PL/SQL » Constraints in Describe (Oracle 10g,windows 7)

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

Constraints in Describe [message #600167]

Fri, 01 November 2013 12:47

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Hi,

I got one doubt...

I want to display columns along with their constraints using describe command

Is it possible?

SQL> desc dept;
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------

 DEPTNO                                             NUMBER(2)
 DNAME                                              VARCHAR2(14)
 LOC                                                VARCHAR2(13)

[Updated on: Fri, 01 November 2013 12:47]

Report message to a moderator