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

One Way would be to check the view "user_tab_privs" This would Not only show if the table exists or not , but what privileges the user has been granted on the table.

Philip E. Sevenants <Sevenants_at_cp-consulting.com> wrote in article <01bcb343$d626f7b0$aac970ce_at_the-machine>...
> Try this:
> Select Count(Table_name) from table_object where Table_name = 'MyTable';
>
> I've been using Oracle 7.1 for the past 7 days and have only some
> familarity with Oracle. Maybe this will point you in the right
 direction.
> --
> Philip Sevenants
> ComputerPeople Consulting Services
> Sevenants_at_NOWHERE.cp-consulting.com
> To send me e-mail, delete the "nowhere."
> Notice:
> Usage of my email address for commercial purposes without my prior
> written consent costs US$ 50 per message. By using this email address
> you agree to this condition. Technical discussions of programming
> problems and solutions are not "for commercial purposes" for the
> purpose of this Notice.
> ------------------------------------------------------------------------
> And for you automated email spammers out there, here is the current
> board of the Federal Communications Commission.
> Chairman Reed Hundt: rhundt_at_fcc.gov
> Commissioner James Quello: jquello_at_fcc.gov
> Commissioner Susan Ness: sness_at_fcc.gov
> Commissioner Rachelle Chong: rchong_at_fcc.gov
> And let's help you send some spam to the USPS, too:
> customer_at_email.usps.gov
>
>
>
Received on Thu Aug 28 1997 - 00:00:00 CDT