Dynamically execute the SQL statement and return a value.

Dynamically execute the SQL statement and return a value of listen (p_sqlinvarchar2); resultvarchar2 (4000); l_tempnumber; beginc: comment; dbms_ SQL .parse (c, p_ SQL, dbms_ SQL .native); ifupper (p_ SQL) li

Dynamic execution of SQL, returns a value PL/SQL dynamic SQL function dyn_ SQL (p_ SQL in varchar2) return varchar2 is c integer; result varchar2 (4000); l_temp number; begin c: = dbms_ SQL .open_cursor; dbms_ SQL .parse (c, p_ SQL, dbms_ SQL .native); if upper (p_ SQL) li

Dynamic execution of SQL, returns a PL/SQL dynamic SQL

  function dyn_sql(p_sql in varchar2) return varchar2 is    c      integer;    result varchar2(4000);    l_temp number;  begin    c := dbms_sql.open_cursor;    dbms_sql.parse(c, p_sql, dbms_sql.native);    if upper(p_sql) like 'SELECT%' then      dbms_sql.define_column(c, 1, result, 4000);      l_temp := dbms_sql.execute_and_fetch(c);      if l_temp > 0 then        dbms_sql.column_value(c, 1, result);      else        result := null;      end if;    else      l_temp := dbms_sql.execute(c);      result := null;    end if;    dbms_sql.close_cursor(c);    return result;  end dyn_sql;