check if table exist

[jass1220]

in oracle 6i i want to write a code that checks if the table is existed or not

for example i want to say

if table history exist then

delete * from history
update from history ......... whatever

else if not exist then

create table history as select * from whatever

end if

 

[dwh123]

you should be able to

select * from tab where table_name = 'history';

Then check your return codes for a hit/miss and code the
delete or create accordingly.

There are other tables in the catalog but tab should work.

 

[sem]

"update from history" is invalid sql statement. You'll also need to use FORMS_DDL built-in to create table from Forms trigger.

Regards, Dima