Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Finding Not Null Constraints

Finding Not Null Constraints

From: John Hough <q6y_at_ornl.gov>
Date: 1997/04/25
Message-ID: <33612C1A.2642@ornl.gov>#1/1 







Can anyone give me a sql query that will distinguish between not null
constraints and column check constraints.  



Both are constraint_type of 'C' and since the search_condition field
is a "LONG" type we have been unable to utilize it in a where clause.



Help,



John Hough
Received on Fri Apr 25 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US