The xls4oracle tool has a free sql extract function.
The SQL function will enable you to extract data from oracle applications. 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 initilize.
The sql statement is entered into a excel sheet enabling you to use excel functions for the build.
Here is some of the features and options:
- apps initialize – extract from org views, profiles, and other setup info
- versions – create a new sheet for each sql execution
- quick execution – just enter table/view name in sheet name – and execute
- bind variables
- horisontal / vertical layout
- csv file extract
- stores extract info (connect, date and sql) as a comment in cell A1