Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- id
- FROM table_name tkn1,
- (SELECT
- id,
- ROWNUM rnum
- FROM table_name
- WHERE
- PROCS_DT is null
- order by PRTY desc, CRET_DT) result
- WHERE tkn1.id= result.id
- AND result.rnum <= 10 FOR UPDATE OF tkn1.id SKIP LOCKED
- create table gm_temp
- as select rownum id, table_name obj_name, date '2011-01-01' + rownum create_date
- from all_tables where rownum < 500;
- CREATE TYPE tab_number IS TABLE OF NUMBER;
- DECLARE
- cursor c_table IS
- SELECT id FROM gm_temp ORDER BY create_date DESC FOR UPDATE OF id SKIP LOCKED;
- t_table_src tab_number := tab_number();
- BEGIN
- OPEN c_table;
- FETCH c_table BULK COLLECT INTO t_table_src LIMIT 10;
- CLOSE c_table;
- dbms_output.put_line(':'||t_table_src.count||':'||t_table_src(1));
- END;
Add Comment
Please, Sign In to add comment