Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Confused about "check" style constraunts
In <to5f39lfa7b5ae_at_news.demon.nl> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> writes:
>"Stan Brown" <stanb_at_panix.com> wrote in message
>news:9luda2$82j$1_at_panix3.panix.com...
>> In <to59ms694kgg1f_at_news.demon.nl> "Sybrand Bakker"
><postbus_at_sybrandb.demon.nl> writes:
>>
>>
>>
>> >2 Please download Toad from www.toadsoft.com
>> >run this query in a sql window, you will get a spreadsheet like output.
>> >Right click on the output window, export it to csv, and post it here.
>> >Alternatively start a schema browser, and export the table definition to
>a
>> >text file.
>>
>> Hmm, a quick glance at this site leads me to the conclusion this only runs
>> on some sort of Microsoft OS, am I correct? If so, I can't use it. How
>else
>> can I provide you with the data you need to help me understand the
>problem?
>>
>>
>>
>> >You query is correct, but I can't imagine why on earth you would have
>that
>> >many check constraints.
>>
>> Hmm, let me check some other tables.
>set colsep "," long 1000
>spool check.csv
>select table_name, constraint_name, search_condition
>from ....
>spool off
Can do. First thing tomorow.
Thanks for the help. Received on Tue Aug 21 2001 - 17:19:16 CDT