Re: PL/SQL: How to check if a table exists or not?

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'