What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-14 03:45:04
oracle drop table if exists
DECLARE l_cnt NUMBER; BEGIN SELECT COUNT(*) INTO l_cnt FROM dba_tab_columns WHERE owner = 'my_owner' AND table_name = 'my_table' AND column_name = 'my_column'; IF( l_cnt = 1 ) THEN EXECUTE IMMEDIATE 'ALTER TABLE my_table DROP COLUMN... Add solution