Re: What is limit on Search Condition in DBA_CONSTRAINTS table
I don't know what version you are on and I only have access to an 8.1.7 database right now but the search_condition column is a long so a set long ... would fix this problem in 8.1.7. To answer your question about underlying tables dba_constraints joins user$, con$, cdef$ (where the actual condition is stored) and obj$ - Brian --- [EMAIL PROTECTED] wrote: > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: What is limit on Search Condition in DBA_CONSTRAINTS table
Cherie, Since SEARCH_CONDITION is LONG datatype, before you run the query, do: SET LONG 90 HTP. Gunawan Yuwono Oracle DBA Kansas City, USA. --- [EMAIL PROTECTED] wrote: > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gunawan Yuwono INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] [EMAIL PROTECTED] on 02/23/2001 08:01:11 AM Message - From: [EMAIL PROTECTED] on 02/23/2001 02:01 PM GMT To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: What is limit on Search Condition in DBA_CONSTRAINTS table
That is because search_condition is a LONG datatype. Do SET LONG 2000 or something large before issuing query and you will see entire text. HTH Rick > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 23, 2001 9:01 AM > To: Multiple recipients of list ORACLE-L > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: What is limit on Search Condition in DBA_CONSTRAINTS table
Try "set long 2000". >>> [EMAIL PROTECTED] 02/23/01 09:01AM >>> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Tim Sawmiller INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
