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_at_juliett.dax.net>


[Quoted] [Quoted] 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 - 11:15:42 CEST

Original text of this message