Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL question

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@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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US