Skip to content

Instantly share code, notes, and snippets.

@agonen

agonen/tips.sql

Last active January 26, 2020 15:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save agonen/a8d21b652f0100807c0e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save agonen/a8d21b652f0100807c0e to your computer and use it in GitHub Desktop.
Download ZIP
oracle pl\sql ,sql tips
Raw
tips.sql
exec DBMS_PARALLEL_EXECUTE.DROP_TASK('mytask');
exec DBMS_PARALLEL_EXECUTE.CREATE_TASK ('mytask');
exec DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_ROWID('mytask', 'BOND', 'BOND_ACTIVE_LIST', true, 100);
-- make sure the the sql statment in parameter 2 is correct (no error will return if the sql is not correct
exec DBMS_PARALLEL_EXECUTE.RUN_TASK('mytask', 'begin for i in (select * from bond_active_list where rowid between :start_id AND :end_id) loop datafeed_mgr.InsertHistBondDateRange(i.BOND_ID) ; end loop; end;', DBMS_SQL.NATIVE,parallel_level => 10);
time -p curl --header "j_username:yyy" --header "j_password:xxxx" http://fe.p.prod.primo.saas.exlibrisgroup.com:1701/cer/data/METADATA/PNX/prquest
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment