Data_Pipeline1.htm |
Script : No Pipe Line
|
|
Now I will use custom PHP DDL query tool , you may use SQL*PLUS or
SQL Developer Tool. Create a table create type tt_pipe1 as table of number; Checking List of Objects: SELECT object_name, object_id, object_type FROM user_objects Query confirms the new objet type created in Scott's account. |
Now Create a table to pipeline or stream data , with PHP DDL web
tool, or SQL Developer
Query injection was valid. Let us confirm the type and function:
SELECT * FROM TABLE (PROCESS_TRANS1(5) ) Create a series of Dates:
Ordering at random select (to_date('31-JAN-2012')+ column_value-1) SERIES from TABLE(PROCESS_TRANS1(5)) order by dbms_random.random select (to_date('31-JAN-2012')+ column_value-1) SERIES from TABLE(PROCESS_TRANS1(5)) order by SERIES desc
|