Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

Latest commit

 

History

History
History
18 lines (16 loc) · 499 Bytes
/

change_baseline_attribute.sql

File metadata and controls

18 lines (16 loc) · 499 Bytes
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
17
18
prompt
prompt First list all baseline present in the system then change attribute
prompt
@BASELINE_INFO
prompt
prompt
prompt Attributes that can be changed are
prompt enabled(yes or no), fixed(yes or no), autopurge(yes or no), plan_name, description
prompt
prompt
declare
myplan pls_integer;
begin
myplan:=DBMS_SPM.ALTER_SQL_PLAN_BASELINE (sql_handle=>'&sql_handle',plan_name=>'&plan_name',attribute_name=>'&what_attribute_to_change',attribute_value=>'&attribute_value');
end;
/
Morty Proxy This is a proxified and sanitized view of the page, visit original site.