Create Type Loop_Type is table of Varchar2(400)
Create or Replace Function Find_Loop_F (P_End_loop in NUmber Default 10) Return Loop_Type PIPELINED
Is
begin
For op in 1..P_End_loop loop
Pipe row (op);
Pipe row ('Value' );
end loop;
--Return;
end;
select * from (Table (Find_Loop_F(200)))
Oracle Tutorial, We have covered all Oracle articles which includes Oracle Database, Application, Framework, Oracle HRM, ADF Training and Financial Training. Further more we have queries and scripts for Oracle EBS Modules.
Subscribe to:
Post Comments (Atom)
How To: Remove all rows from view object (VO) in OAF & ADF
This is the basic requirement when we are working with oracle OAF. In which we need to removed the all rows from the table. The best use ca...
-
Create Type Loop_Type is table of Varchar2(400) Create or Replace Function Find_Loop_F (P_End_loop in NUmber Default 10) Return Loop_Typ...
-
Run JavaScript Method in Java / ADF & OAF ** it is not Oracle standard. Example Code : try { ScriptEngineManager manager ...
-
The exact lines of Developers’ guide for use JavaScript are as follows: “UIX and the OA Framework are rapidly adding new features to provide...
No comments:
Post a Comment