Text importer filter

[AntonioCK]

I am trying to use filter in text importer tool. My file is pure txt file. How to use filter?. I have tried # > 0, Field2 > 0, colum name of table > 0. But nothing works.

 

[Marco Kalter]

To filter the file contents you can enter any valid SQL expression in the Filter field. You can refer to a field value through a bind variable with the field name. For example, to include only employees from department 10 with a job other than 'CLERK', you can enter the following filter expression:

:deptno = 10 and :job 'CLERK'

 

[AntonioCK]

After writing the filter like you said,

:a > '200801'

and click apply, PLSQLDEV send message Error in filter expression. ORA-01008: not all variables are bind.

 

[AntonioCK]

Marco remember you, I am importing txt file. Please answer me, the filter will be applied over txt file, before the record is loaded to oracle table?

 

[Marco Kalter]

Note that for your example

:a > '200801'

you must have a column named 'A' in your table. Is this the case?