Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table Existence
Yeah,
IF you have the DBA privileges then you can check it out at DBA_TABLES (Pl. check for the correct syntax)
If you are a user then you can query the user_tables to find out about the existence of a table. I'm not quit sure that whether you would be able to see the Table names outside of your owner ships.
On Mon, 21 Feb 2000, Louis Frolio wrote:
> Is there a sql command in Oracle that will tell me whether or
> not a table exists? In T-SQL the command "IF EXISTS(..)" does
> just this. Any help would be appreciated.
>
> L
>
>
>
Sam .T
600 West 26Th Street, Phone : (512) 474-2328 Apartment #E 144, E-mail: sambavan_at_cs.utexas.edu Austin, sambavan_at_mail.utexas.edu Texas - 78705. sambavan_at_tenet.edu ------------------------------------------------------- What I do today is important because I'm exchanging a day of my life for it --------------------------------------------------------Received on Mon Feb 21 2000 - 17:58:22 CST