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

Home -> Community -> Usenet -> c.d.o.tools -> How to check the existance of a table ?

How to check the existance of a table ?

From: Robert Vabo <robert.vabo_at_gecko.no>
Date: Thu, 31 Aug 2000 09:15:42 GMT
Message-ID: <2npr5.12195$541.2514526@juliett.dax.net>

I want tocheck if a table exist in the database via a SP.

Procedure SP_TableExist
( TableName varchar2)
IS
if exists(select * from User_Objects WHERE Object_Name = || TableName)

    return 1;
else

    return 0;
end if;
end SP_TableExist;

Any suggestions ?

--
Regards
Robert Vabo
Application developer
Gecko Informasjonssystemer AS
www.gecko.no
robert.vabo_at_gecko.no
Received on Thu Aug 31 2000 - 04:15:42 CDT

Original text of this message

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