Hello,
Can someone help in the performance of my sqr program.

++++++
Query 1 :

Select
AA,
BB,
CC
From
Table 1

From the result of query 1, need to selecting :
Query 2 :
Select
AA,
BB,
CC,
DD,
EE
From
Table 1
where
AA = AA and
DD = CC

From the result of Query 2 :
Select
XX
from
Table3
where
AA=AA
BB=EE


The result from Table 2 and Table 3 i insert into table and commit on each row.

The result of the sqr is then extracted from this table onto an array to print onto Xl sheet in column wise.

Any help please ?

Thank you
Raman

Thanks for posting your question!

Recommended approach:

§ Use bulk INSERT using the /*+ APPEND */ HINT (assuming your database is ORACLE.

§ Use SUBQUERY or JOINS instead of performing SELECT multiple times.

Example:

INSERT /*+ APPEND */ INTO TABLE_X

SELECT

AA,

BB,

XX

FROM TABLE_1, TABLE_2, TABLE_3

WHERE

TABLE_1.COL1 = TABLE_2.COL1

AND TABLE_2.COL2 = TABLE_3.COL2

Thanks

Nitin Pai

I can not get the worklist to populate in Peoplesoft financials. Version 8.48

Any installation guide for setup. Wanted to get the delivered approval process working for a demo.

Thanks for posting your question!

Troubleshooting steps (assuming Expense Workflow):

§ Ensure that Workflow Enabled is checked in the installation options (Setup Financials/Supply Chain > Install > Installation Options)

§ Check the Approver Information

§ Check the Supervisor for the operator submitting the Expense (Travel and Expenses > Manage Employee Information > Update Profile > Organizational Data)

§ Submit Expense

§ Log on to the environment using the OPRID for the manager and check the worklist

Please let us know if this helped.

Thanks

Nitin Pai

Posted by Nitin Pai
Comments (0)
October 16th, 2008

Comments (0)