Re: PL/SQL: How to check if a table exists or not?
From: (wrong string) Žgela <Mario.Zgela_at_nbh.hr>
Date: 1997/08/28
Message-ID: <01bcb3c6$ae083040$19d998c2_at_Mario.nbh.hr>#1/1
Date: 1997/08/28
Message-ID: <01bcb3c6$ae083040$19d998c2_at_Mario.nbh.hr>#1/1
First I can think of is to trap the ORA error (ORA-00942 table or view does
not exist) in EXCEPTION
part of a program.
> How can I check in PL/SQL if a table exists or not. Is there a built in
> function that can return TRUE or FALSE? I know the table name, I just
> want to know if it's there or if I have to create it. Thanks in
> advance.
Received on Thu Aug 28 1997 - 00:00:00 CEST