Re: PL/SQL question

On 5 Sep 1997, Dmitry Babitsky wrote:

> I need to find out in my procedure if a table exists and drop and recreate
> it.

A possible form is:

BEGIN
  select count(*) into aux from TABLA;
EXCEPTION
  WHEN OTHERS THEN
    dbms_output.put_line('The table TABLA does not exists'); END; To create and drop it, you must use Dynamic SQL.

Be lucky!
ppgg_at_lcc.uma.es Received on Mon Sep 08 1997 - 00:00:00 CDT