DBMS_SQL mit Oracle 12c Release 2

http://www.oracle.com/technetwork/issue-archive/2017/17-mar/o27plsql-3616177.html

returning with insert .. select

http://www.oracle-developer.net/display.php?id=413

PL / SQL Arrays

http://www.tutorialspoint.com/plsql/plsql_arrays.htm

http://stackoverflow.com/questions/7012625/oracle-pl-sql-how-to-create-a-simple-array-variable

Recordsets mit VB

https://support.microsoft.com/de-de/kb/176086

SQL-Injection unterbinden

https://de.wikipedia.org/wiki/SQL-Injection

Ref Cursor

http://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets.php

http://oracle-base.com/articles/8i/complex-recordsets.php

http://www.martinbulinski.de/plsql-tutorial/dynamisches-sql-mit-ref-cursor

https://msdn.microsoft.com/de-de/library/bw9eczdk%28v=vs.110%29.aspx

http://sql-plsql.blogspot.de/2007/05/oracle-plsql-ref-cursors.html    !!!

http://www.cmoser.de/blog-archiv.html?month=201307

http://www.java2s.com/Tutorial/Oracle/0500__Cursor/Definerefcursorvariable.htm

http://www.asktheoracle.net/what-is-ref-cursor.html

http://www.mathworks.com/matlabcentral/newsreader/view_thread/260796

http://www.akadia.com/services/ora_return_result_set.html

http://www.toadworld.com/platforms/oracle/w/wiki/1856.ref-cursor-type.aspx

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.plsql.doc/doc/c0053892.html

http://www.morganslibrary.org/reference/plsql/ref_cursors.html

http://www.databasedesign-resource.com/ref-cursor.html

Example: Kopieren einer Tabelle per PL/SQL-Block

DECLARE

  l_sql           varchar2(32767);

  c_tab_comment   varchar2(32767);

  PROCEDURE run(p_sql varchar2) AS

  BEGIN

    execute immediate p_sql;

 

  END;

BEGIN

  run('create table EMP_TMP as select * from EMP where ' || 11 ||

      ' = 1');

  select comments

    into c_tab_comment

    from sys.all_TAB_comments

   where owner = 'TEST'

     and table_name = 'EMP'

     and comments is not null;

  run('comment on table TEST.EMP is ' || '''' || c_tab_comment || '''');

  for tc in (select column_name

               from sys.all_tab_cols

              where owner = 'TEST'

                and table_name = 'EMP') loop

    for c in (select comments

                from sys.all_col_comments

               where owner = 'TEST'

                 and table_name = 'EMP'

                 and column_name = tc.column_name) loop

      run('comment on column TEST.EMP.' || tc.column_name ||

          ' is ' || '''' || c.comments || '''');

    end loop;

  end loop;

EXCEPTION

  WHEN OTHERS THEN

    NULL;

END;

########################################################

CREATE TABLE new_table
  AS (SELECT *
      FROM old_table WHERE 1=2);

aus:
[http://www.techonthenet.com/sql/tables/create_table2.php]