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?

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: unable to insert column from other table
Next Topic: sql*plus Report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 07 00:40:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.