Thursday, April 17, 2025

Breaking News
>> Securing and encrypt View State and Cookies values  >> Page has one or more controls that do not correspond with   >> “The Controls collection cannot be modified because the control contains code blocks”  >> How to fix "Validation(): Element 'xxxx' is not supported  >> How to create a new session in ASP.NET programmatically  >> MySQL Database Backup using mysqldump command    

Editors Picks

Tuesday, December 6, 2011

drop table if exists in oracle sql


declare tbl_exist number;
   BEGIN
        select count(*) into tbl_exist from user_tables where Upper(table_name)=Upper('test1');
        DBMS_OUTPUT.put_line(tbl_exist);
        if tbl_exist = 1 then
           EXECUTE IMMEDIATE 'drop table test1';
        end if;
   end;

No comments :

Post a Comment

Contact Us

Name

Email *

Message *