SQL

by Thomas Lundqvist

The xls4Oracle tool has a sql extract function.

The SQL function will enable you to extract data from an oracle database. You is given the choice to logon to oracle applications and select a responsibility. This enables you to build sql’s using all setup and profiles that comes from apps initialize.  The sql statement is entered into a excel sheet enabling you to use excel functions for the build. This is handy build a long in list. Here is some of the features and options:

  • apps initialize – extract from org views, profiles, and other setup info
  • versions option – create a new sheet for each sql execution
  • bind variables
  • horisontal / vertical layout
  • stores extract info (connect, date and sql) as a comment in cell A1

All SQL for download:

Download xls4Oracle

Leave a Reply