Hello,
I have a handful of SQL scripts that I would like to schedule using Oracle SQL Developer and have the results saved to a network or SharePoint site. Can you please help me or point me to some links that would be useful? I had a hard time finding this information thru the knowledge base and web searches. Note that I am a novice in SQL and have no experience with PL (but am willing to learn the basics).
For example, here is a script I would like to run and have the results stored somewhere else where I can pick it up when finished:
Select
mmt.ORGANIZATION_ID,
mmt.acct_period_id,
ood.SET_OF_BOOKS_ID,
ood.ORGANIZATION_NAME,
--oap.PERIOD_YEAR,
--oap.PERIOD_NUM,
--oap.PERIOD_NAME,
mmt.TRANSACTION_ID,
gcc.SEGMENT1,
gcc.segment4,
gcc.CODE_COMBINATION_ID,
mmt.TRANSACTION_DATE,
mmt.INVENTORY_ITEM_ID,
mmt.TRANSACTION_TYPE_ID,
mtt.TRANSACTION_TYPE_NAME,
mtt.TRANSACTION_ACTION_ID,
mtt.TRANSACTION_SOURCE_TYPE_ID,
mtt.DESCRIPTION,
mmt.PRIMARY_QUANTITY,
mmt.TRANSACTION_UOM,
mta.ACCOUNTING_LINE_TYPE,
mta.BASE_TRANSACTION_VALUE,
mta.RATE_OR_AMOUNT,
mta.GL_BATCH_ID
From mtl_material_transactions mmt,
mtl_transaction_accounts mta,
MTL_TRANSACTION_TYPES mtt,
GL_CODE_COMBINATIONS gcc,
org_organization_definitions ood
Where mmt.transaction_ID = mta.transaction_ID
AND mmt.TRANSACTION_TYPE_ID=mtt.TRANSACTION_TYPE_ID
AND mta.REFERENCE_ACCOUNT = gcc.CODE_COMBINATION_ID
AND mta.ORGANIZATION_ID=ood.ORGANIZATION_ID
AND gcc.segment1 = xxxx
AND mta.TRANSACTION_DATE>='30-DEC-2013'
AND mta.TRANSACTION_DATE<='02-APR-2014';
Any help is greatly appreciated. Thanks!