SQL & PL/SQL

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!

How to convert number to char?

955649Oct 3 2012 — edited Oct 3 2012

Hi sir,

I have one variable which i used in query that is v_day number=12

i want it to convert in char so i can insert easily this value to my table column which has varchar2 datatype.

thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2012

Added on Oct 3 2012

#11g

8 comments

488 views