http://www.oracle.com/technetwork/issue-archive/2017/17-mar/o27plsql-3616177.html
PL/SQL
Dienstag, 16. Mai 2017
Freitag, 3. März 2017
Mittwoch, 27. Juli 2016
Mittwoch, 13. Juli 2016
Donnerstag, 5. November 2015
Mittwoch, 20. Mai 2015
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
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
Mittwoch, 10. September 2014
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]
########################################################
CREATE TABLE new_table
AS (SELECT *
FROM old_table WHERE 1=2);
aus:
[http://www.techonthenet.com/sql/tables/create_table2.php]
Abonnieren
Posts (Atom)