2.3 Dynamic query in pl sql

referencing

• https://docs.oracle.com/cd/B10501_01/appdev.920/a96590/adg09dyn.htm

dynamic query

/* dynamic query in pl sql 1*/
declare 
nRET number;
begin
 EXECUTE IMMEDIATE 'select count(*) from R00DMDVCS '
    into nRET;   
    DBMS_OUTPUT.PUT_LINE(nRET);
end;


/* dynamic query in pl sql 2*/
declare 
nRET number;
vSQL_QUERY VARCHAR2(2000);
begin
 vSQL_QUERY := 'select count(*) from R00DMDVCS ';
 EXECUTE IMMEDIATE vSQL_QUERY
    into nRET;   
    DBMS_OUTPUT.PUT_LINE(nRET);
end;