Re: PL/SQL: How to check if a table exists or not?
From: <twod_at_not.valid>
Date: 1997/08/29
Message-ID: <5u6qo7$grd$1_at_vnetnews.value.net>#1/1
Date: 1997/08/29
Message-ID: <5u6qo7$grd$1_at_vnetnews.value.net>#1/1
seci_at_ludens.elte.hu wrote:
: select count(*) into x from user_tables where table_name =
: the_name_you_are_looking_for;
: if x=0 then
: -- create it
: end if;
What if the table is in another schema (ie is owned by another user) ?
IAP
-- In an attempt to reduce junk email I use an invalid 'From' address. My correct email address can be determined by replacing 'not.valid' with with 'value.net'Received on Fri Aug 29 1997 - 00:00:00 CEST