Oracle Analytics and AI

Anantharao27

Summary

Sequence Generation

Content

Hi All,

I have a very weird requirement,

1.     Create a sequence (Oracle Sequence ) in query template.

2.     Pass sequence as parameter in ReportTrigger which will insert some data into temporary table based on key.

3.     Retrieve inserted records using the key.

Any ides how to implement.

Thomas Dodds

Do this all the time but never used a sequence (seems like overhead for a temp table) ...

set a variable just before writing the rows for your data_key as something similar to:

select

to_number(to_char(sysdate,'DDMMYYYYHH24MISS')) insert_key

from dual;

insert_key = 16062017134825

^ then select records based on MAX(insert_key)