Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sequence Generation

Received Response
1
Views
1
Comments
Anantharao27
Anantharao27 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

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.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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)