Re: PL/SQL question

From: Pepe Galindo <ppgg_at_lcc.uma.es>
Date: 1997/09/08
Message-ID: <Pine.GSO.3.96.970908105347.7401A-100000_at_sol10>#1/1


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 CEST

Original text of this message