Try FNDLOAD. It can download concurrent data ( executable,define , parameters) from server into a text file. It can upload them to another server also.
You can search FNDLOAD in metalink for details.
Do you mean that you need to :
update Z_LOCATION
set workorder_no =
(
select Z_ACTIVITY.workorder_no
from Z_ACTIVITY, Z_INVOICE
WHERE Z_ACTIVITY.ITEM_NO = Z_INVOICE.ITEM.NO
)
where ......
Is that what you want?
Dear all,
I am going to decrease the number of query boxes in Oracle Report. Some of the query boxes need to join many tables.
Our app. server is much powerful than report server, could it be faster if I create a view to join the tables, and select data from the view in Oracle Report?
Thanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.