comparing empty string in PL/SQl
449906Jul 7 2006 — edited Jul 9 2006Hi
I am reading a text file then inserting into a table of two colums date and varchar.
The text file have few empty lines as well which have been catered for by using if condition such as
if s = null
then Insert into blah blah
The problem is if those lines have some blank characters it doesnt work because the line is not null but have some empty characters.
Please help