Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Long data tye 2
- Thread starter mputmtab
- Start date
listener22
Programmer
Isn't there a way to convert a long to a varchar2, assuming
the long isn't over 32k or whatever the current limit is? You could
then convert the varchar2 to a number. Jim
oracle, vb
the long isn't over 32k or whatever the current limit is? You could
then convert the varchar2 to a number. Jim
oracle, vb
-
2
- #3
Jim's right, as long as your LONG column contains less than 32k of information, you could select the LONG column in to a VARCHAR2 variable (of 32767 length) in PL/SQL and then perform an INSTR function on the VARCHAR2 column, searching for your to_char(NUMBER) column value. Nasty problem!
best-o-luck,
bcouse
best-o-luck,
bcouse
- Status
Similar threads
- Locked
- Question