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


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.

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

Original text of this message