| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Any way to "conditionally" drop a table?
Scott Watson wrote:
>Try creating a callable statement and then execute something like the following.
>
>"begin drop table tablename cascade constraints; exceptions when others then null; end;"
>
>Hth
>Scott Watson.
>
>
>
Did you try this before you suggested it?
And in answer to that rhetorical question ... why did you post it?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Mon Oct 27 2003 - 19:34:32 CST
![]() |
![]() |