FilesExpand file tree

 main

/

drop_sql_profile.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

16 lines (16 loc) · 423 Bytes

 main

/

drop_sql_profile.sql

Top

File metadata and controls

• Code
• Blame

16 lines (16 loc) · 423 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

undef sql_id

set serveroutput on

set verify off

accept sql_id prompt 'Enter sql_id :'

accept a prompt 'YOU SURE WANNA DROP THIS SQL PROFILE?[N]: '

begin

if('&&a'='Y') then

dbms_output.put_line(CHR(10)||'Deleting this profile.....');

DBMS_SQLTUNE.drop_sql_profile ( name => 'PROFILE_&sql_id', ignore => FALSE);

else

dbms_output.put_line(CHR(10)||'You chose not to delete. exiting..');

end if;

end;

/

undef sql_id

undef a