Home » SQL & PL/SQL » SQL & PL/SQL » unable to view constraints
unable to view constraints [message #196673] Fri, 06 October 2006 08:12 Go to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member

sir,
i unable to view constraints of the table.
while using command i.e

select constraints_name, constraints_type
from users_contraints
where table_name='sales_master';

0 rows selected

where did i had done wrong?
Re: unable to view constraints [message #196675 is a reply to message #196673] Fri, 06 October 2006 08:15 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Your table name needs to be in upper case.
Re: unable to view constraints [message #196677 is a reply to message #196675] Fri, 06 October 2006 08:18 Go to previous message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
oh ho that's why i m getting zero rows selected..
thank u lot..Cthulhu
Previous Topic: unable to insert column from other table
Next Topic: sql*plus Report
Goto Forum:
  


Current Time: Thu Dec 08 08:41:48 CST 2016

Total time taken to generate the page: 0.12563 seconds