Home » SQL & PL/SQL » SQL & PL/SQL » find check constraint what i have in specific column from data dictionary (oracle9i)
find check constraint what i have in specific column from data dictionary [message #283389] Tue, 27 November 2007 00:32 Go to next message
aaharun
Messages: 2
Registered: July 2007
Location: Bangladesh
Junior Member
I want to know what check constraint i have in my column of a table
Re: find check constraint what i have in specific column from data dictionary [message #283393 is a reply to message #283389] Tue, 27 November 2007 00:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you check "user_constraints" view ?
Re: find check constraint what i have in specific column from data dictionary [message #283407 is a reply to message #283389] Tue, 27 November 2007 01:14 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Look for search_condition of the user_constraints.
Previous Topic: order by in Minus Operator
Next Topic: Display REFCURSOR results through PL/SQL
Goto Forum:
  


Current Time: Fri Dec 09 00:16:26 CST 2016

Total time taken to generate the page: 0.05774 seconds