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
Best helpers
Kamchatka
+5
Hoang Speed
+5
Lee Wright
+5
Azil
+5
Philip
+5
Brocolio
+5
Jax frost
+5
Felix Jordan
+5
Jiimms
+5
Geke
+5
WordLover
+5
Morgan falk
+5
Tiberia
+5
Vkarve
+5