sophos

Search This Blog

Parent-Child Hierarchy in OBIEE

January 04, 2015

Get link
Facebook
X
Pinterest
Email
Other Apps

Great explanation of Parent-Child Hierarchy in OBIEE by Anupam...Please find link

http://prasadmadhasi.com/2011/11/15/hierarchies-parent-child-hierarchy-in-obiee-11g/

OBIEE

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Pipelined Table Functions

Table functions are used to return collections that mimic tables. They can be queried like a regular table by using the TABLE function in the FROM clause Regular table functions require collections to be complete before they are returned causing bottlenecks during large Extraction Transformation Load (ETL) operations. Pipelining negates the need to build huge collections by piping rows out of the function as they are created, allowing subsequent processing to start before the entire collection is fully populated. CREATE TYPE integer_nt_type is table of integer / CREATE OR REPLACE FUNCTION get_tab_nos(n IN INTEGER) RETURN integer_nt_type IS num_tab integer_nt_type:=integer_nt_type(); BEGIN FOR i IN 1..n LOOP num_tab.extend; num_tab(num_tab.last):=i; END LOOP; RETURN num_tab; END; / CREATE OR REPLACE FUNCTION get_nos(n in integer) RETURN integer_nt_type PIPELINED IS BEGIN FOR i IN 1..n LOOP PIPE ROW(i); END LOOP; RETURN; END; / SELECT * FROM TABLE(get_nos(5)); PIPELINED Clause This optio...

How to find long running query in oracle.

How to find long running query in oracle. SELECT l.sid, l.start_time, l.username, l.elapsed_seconds a.sql_text, a.elapsed_time FROM v$session_longops l, v$sqlarea a WHERE a.elapsed = l.elapsed_seconds AND l.elapsed_seconds > 1

Powered by Blogger

Parent-Child Hierarchy in OBIEE

Comments

Post a Comment