Frank Schmitt
Member²
When using the "Export tables" functionality, I can set a WHERE clause to limit the data to export:
However, this is ignored in the "copy as command" feature. The generated script looks like this:
But if I manually add the WHERE clause to the script like this:
it works. Could you please fix this so that "copy as command" takes the configured WHERE clause into account?
Code:
value like 'x%'
However, this is ignored in the "copy as command" feature. The generated script looks like this:
Code:
Export Tables=PLSQLDEV_EXPORT_DEMO1 Method="PL/SQL Developer" Compress IncludeStorage IncludePrivs Filename="C:\Users\schmitf2\Downloads\plsql-export-demo\export-table1.pde"
But if I manually add the WHERE clause to the script like this:
Code:
Export Tables=PLSQLDEV_EXPORT_DEMO1 Method="PL/SQL Developer" Compress IncludeStorage IncludePrivs Filename="C:\Users\schmitf2\Downloads\plsql-export-demo\export-table1.pde" WHERE="value like 'x%'"
it works. Could you please fix this so that "copy as command" takes the configured WHERE clause into account?