oracle drop sequence if exists

Solutions on MaxInterview for oracle drop sequence if exists by the best coders in the world

Search
showing results for - "oracle drop sequence if exists"
Stefania
23 Apr 2016
1DECLARE
2    s_exist NUMBER(1);
3BEGIN
4    SELECT CASE WHEN exists(SELECT * FROM ALL_SEQUENCES 
5                           WHERE SEQUENCE_NAME = 'seq_name') THEN 1
6       	ELSE 0 
7    END INTO s_exist FROM DUAL;
8    IF s_exist = 1 THEN
9        EXECUTE IMMEDIATE 'DROP SEQUENCE seq_name';
10    END IF;
11END;
similar questions
pl sql drop triggeroracle drop programdrop all triggers oracleoracle drop rulespl sql trigger determine if insert or update or deleteoracle drop chain steporacle drop jobcheck if table exists oracleoracle drop default valuehow to delete duplicate rows in oracleplsql code for deleting a row from nested table in oraclesql drop view if existsoracle drop constraintoracle drop type if existsoracle create program if no existsoracle drop job if existsdrop table if exists oracleoracle sql drop sequenceoracle drop index if existsoracle current sequence valuealter sequence set current value oracleoracle drop temporary tableoracle sql drop column if existsoracle drop chaindelete rows table oracle
queries leading to this page
oracle drop sequence drop sequence if exists oracledrop sequencedelete sequence oracleoracle drop sequence if exists