Hi, i tried exporting data and then importing it back as part of a where clause in a select query. but it does not give the desired result. it somehow always adds some characters to the output while importing.
i am using : .export data....
.import data.. using... select fac from table where ssi=:cola and ssfi=:colb;
Hi, This is the little code that i want to test. cast did not solve my problem.i have tried report, data and indicdata type of export/import.first i am exporting, then importing the result to evaluate other query. i have even tried using substr to remove the extra character, but it still does not work. tried casting the entire result also. PLZ PLZ PLZ help.