Re: PL/SQL: How to check if a table exists or not?
From: <seci_at_ludens.elte.hu>
Date: 1997/08/29
Message-ID: <1997Aug29.084857.42571_at_ludens>#1/1
Date: 1997/08/29
Message-ID: <1997Aug29.084857.42571_at_ludens>#1/1
hello
In article <34047555.2D31BB02_at_icepr.com>, "Michael A. Casillas" <casillas_at_icepr.com> writes:
> Yet another one:
>
> 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.
[Quoted] select count(*) into x from user_tables where table_name =
the_name_you_are_looking_for;
if x=0 then
- create it end if;
>
> Michael Casillas
>
HTH
peter
Received on Fri Aug 29 1997 - 00:00:00 CEST