Revision [3635]
Last edited on 2010-02-03 07:50:20 by WikiAdminAdditions:
%%(SQL)
BEGIN
:stid := 'some_name';
END;
/
||rtrim(options)||' '||rtrim(object_name)|| ' '
||'(cost= '||cost||', cardinality='||
"Query Plan"
AND upper(statement_id) = upper(:stid)
CONNECT BY PRIOR id = parent_id AND upper(statement_id) = upper(:stid);
BEGIN
:stid := 'some_name';
END;
/
||rtrim(options)||' '||rtrim(object_name)|| ' '
||'(cost= '||cost||', cardinality='||
"Query Plan"
AND upper(statement_id) = upper(:stid)
CONNECT BY PRIOR id = parent_id AND upper(statement_id) = upper(:stid);
Deletions:
||'(cost= '||cost||', cardinality='||cardinality||')'
"Query Plan"
AND upper(statement_id) = upper('some_name')
CONNECT BY PRIOR id = parent_id AND upper(statement_id) = upper('some_name');
