Home » SQL & PL/SQL » SQL & PL/SQL » searching tabe character in a variable always returns zero
searching tabe character in a variable always returns zero [message #36905] Wed, 02 January 2002 20:42 Go to next message
sulinder singh
Messages: 10
Registered: January 2002
Junior Member
Hi all,
I am reading a file using the utl_file package from oracle,
I read a line from a file which is tab separated, from the entire line that is read in the variable ,i want to find the postion of the tab character,
so i hv used the function instr, but it never gives the position of tab character, i tried searching for 't' or '~t' or simply ' ',
Does anyone know what is the character to be searched for
for e.g contents of file
-----------------------------
test tester

----------------------

i get the entire line in a variable
i'e 'test tester'
in this variable when i search for tab it fails
can anyone throw some light on this....

Thanks and Regards

Sulinder Singh

----------------------------------------------------------------------
Re: searching tabe character in a variable always returns zero [message #36909 is a reply to message #36905] Thu, 03 January 2002 07:28 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
check for chr(9)

----------------------------------------------------------------------
Previous Topic: How to send mail to more than one people from plsql
Next Topic: Member Functions of Oracle Objects
Goto Forum:
  


Current Time: Fri Mar 29 09:59:03 CDT 2024