Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

_reverse_ function to chr()

414229Jul 12 2004 — edited Jul 13 2004

hi @ all,

I'm having a problem here: Using HTML-DB I use the function chr() to convert a number from a table in the db to show a character on my frontend. Example:

select chr(RACK+64) d, .....

this translates the following from db -> frontend:

db frontend
1   A
2   B
3   C
.   ...

now I need to translate the values back: from the frontend (e.g. 'A') to a valid db-value, a number (e.g.'1').

Is there some _reverse_ function to chr() ?!?

Thanks,

-David-

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2004

Added on Jul 12 2004

#general-database-discussions

4 comments

1,002 views