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]

APEX als Rapid Application Development Tool

http://www.heise.de/developer/artikel/Oracle-APEX-Rapid-Application-Development-Werkzeug-fuer-Webanwendungen-227214.html

https://blogs.oracle.com/apexcommunity_deutsch/de/

Error Handling / Exceptions

Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2)

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/errors.htm#LNPLS007

Uni Potsdam - Wiki (Stefan Uhlmann)

http://fara.cs.uni-potsdam.de/~uhlmann/19/ch09.html

For Cursor Loop - Example

  set serveroutput on;
  --
  DECLARE
    v_anzahlDS NUMBER(20);
  BEGIN
    FOR n IN (SELECT owner, table_name
                FROM all_tables
               WHERE owner = 'SCOTT' order by 1)
    LOOP
      execute immediate 'select count(*) from '|| n.owner ||'.'|| n.table_name INTO v_anzahlDS;
      dbms_output.put_line(n.table_name || '   ' || v_anzahlDS);
    END LOOP;
  END;