FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
Oracle-Database-Scripts/drop_sql_profile.sql at main · co360/Oracle-Database-Scripts · GitHub
Uh oh!
There was an error while loading.
Please reload this page
.
co360
/
Oracle-Database-Scripts
Public
forked from
fatdba/Oracle-Database-Scripts
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
Oracle-Database-Scripts
/
drop_sql_profile.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
16 lines (16 loc) · 423 Bytes
Breadcrumbs
Oracle-Database-Scripts
/
drop_sql_profile.sql
Copy path
File metadata and controls
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
Back
|
FazBrowse Home
|
New Git URL