Joe Simunac
Member²
I just tried to use the SQL function on the text importer for the first time. According to the documentation, you can enter anything that can be processed by Oracle. I had a list of SSNs and wanted to get rid of the '-'. So I typed:
substr(#,1,3)||substr(#,5,2)||substr(#,8,4)
It recognized the first '#' and replaced it with the first SSN, but gave an error on all other '#' and failed. Seems like this should work.
Another problem - when I close the text importer, the text file I was using was left open and was not released until I shut down PL/SQL Developer. It should release the file when the text importer either closes or finishes.
Thanks,
Joe
substr(#,1,3)||substr(#,5,2)||substr(#,8,4)
It recognized the first '#' and replaced it with the first SSN, but gave an error on all other '#' and failed. Seems like this should work.
Another problem - when I close the text importer, the text file I was using was left open and was not released until I shut down PL/SQL Developer. It should release the file when the text importer either closes or finishes.
Thanks,
Joe
