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
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
A possible form is:
BEGIN
> it.
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