Re: What is limit on Search Condition in DBA_CONSTRAINTS table

You can issue following sqlplus commands before the query:

set wrap on
set long 777 (maximum width for LONG 8.1.5 )

HTH Eveleen

Please respond to ORACLE-L_at_fatcity.com

Cherie_Machler_at_gelco.com on 02/23/2001 08:01:11 AM

                                                                                
  Message - From: Cherie_Machler_at_gelco.com on 02/23/2001 02:01 PM GMT           
                                                                                



                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 cc:      (bcc: Eveleen Xu/NNIB/NNNG)                         
                                                              
                                                              
                                                              
 Subject: What is limit on Search Condition in                
          DBA_CONSTRAINTS table                               
                                                              

One of our developers is wondering why they can't see all of their check constraint options when they query from DBA_CONSTRAINTS, USER_CONSTRAINTS, ALL_CONSTRAINTS. The Search Condition column only shows about 60 characters, no matter what you set your output string to in SQL*Plus.

How can we see the rest of the Search Condition? Is there an underlying table that this view is based on?

Cherie Machler
Gelco Information Network

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: exu_at_nnng.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).