Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> How to check the existance of a table ?
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.noReceived on Thu Aug 31 2000 - 04:15:42 CDT
![]() |
![]() |