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
Karma: 0
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
Karma: 0
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:...
Karma: 0
Senior Member

Look for search_condition of the user_constraints.
Previous Topic: fetch out of sequence
Next Topic: Why I can't read sys.v_$session from procedures or functions?
Goto Forum:
  


Current Time: Tue Aug 22 10:05:11 CDT 2017

Total time taken to generate the page: 0.07242 seconds