enhancement for EXPORT TABLES - Feature

[stefan_dd]

It would be nice to specify a WHERE-Clause when Selecting more than 1 table to export (master-detail-tables).

Something like

TABLE_NAME.FIELD_NAME = VALUE

At the moment you only get an error message like:
ORA-00904: "TABLE_NAME"."FIELD_NAME": invalid identifier.

Stefan

 

[Marco Kalter]

I assume you would like to use a different where clause for each selected table?

 

[stefan_dd]

Example

Master table (DEPARTMENT):
ID DEPT_NAME
CO Controlling
IS Information Systems
SU Support

Detail table (EMPLOYEES)
ID NAME DEPT_ID
001 Stefan IS
002 Marco SU
003 Ralf CO
004 Berit IS

Now, it's possible to export all master-detail-entries by selecting both tabels in the export window.

But I'am only interested in the master-detail-entries of the IS-Department. How can I do that (except the possibility of exorting all and erasing the wothless stuff)?

When exporting only one table, the where-clause works very well.

 

[Marco Kalter]

This is currently not possible. It would only be possible if you could supply a different where clause for different tables.

For the master it would be id='IS'
For the detail it would be dept_id='IS'

I have added this to the list of enhancement requests.