Re: Confused about "check" style constraunts

"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

should do

Hth,

Sybrand Bakker, Senior Oracle DBA

should do Received on Tue Aug 21 2001 - 14:54:10 CDT