Technical Notes

SQL DECLARE    sql_text   VARCHAR (1000); BEGIN    sql_text := ' exec P_COMPILE_INVALID_OBJECTS()';    DBMS_OUTPUT.PUT_LINE (s...

e.g. DECLARE    v_name      VARCHAR (100) := &i1;    v_surname   VARCHAR (100) := &i2; BEGIN     EXECUTE IMMEDIATE 'inse...