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>
Date: Thu, 31 Aug 2000 09:15:42 GMT
Message-ID: <2npr5.12195$541.2514526_at_juliett.dax.net>
I want tocheck if a table exist in the database via a SP.
Procedure SP_TableExist
return 1;
return 0;
Any suggestions ?
( TableName varchar2)
IS
if exists(select * from User_Objects WHERE Object_Name = || TableName)
else
end if;
end SP_TableExist;
--
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