Category Archives: SQL
The xls4Oracle Profit package enable you to do FIFO calculation on Oracle database objects. Pls. visit the The xls4Oracle Profit package with FIFO calculation page for further info and download.
The @ext script will first give you a filtered list of all objects. Use the sqlplus copy paste to select the objects you want to extract.
The obj script gives youthe fastpath to the all_objects system view. You can find all database objects in the all_objects view. So if you folow good naming standards you can ask about all objects where object_name like ‘XX%’ and you … Continue reading
Create the readonly role Grant select on all tables and views, selectable from apps, to the readonly role Create the readonly users For each readonly user: Grant the readonly role and create logon triggers to alter schema to apps. Use policy … Continue reading
In R11 api’s was found in irep – in R12 api’s are found in the database. The “7417 Prototype scripts for API’s – R12” zip file is generated using the proto sql scripts from the sql4oracle.zip file. Extract was generated using … Continue reading
This view contains most objects in Oracle Applications. Use if for searching for customizations, forms, personalizations, workflow, value sets, profiles. If you can use FNDLOAD or WFLOAD the download and upload commands is generated for you.
download id="114" format="7" autop="false"]
Added new feature to refresh a sql sheet. The refresh will use the comment in the A1 cell to generate a new extract. When you press the xls4Oracle/sql button and the cursor is in a cell with an xls4Oracle comment … Continue reading