Skip to Main Content

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!

To_char to_number combination

969983Oct 22 2012 — edited Oct 22 2012
Hi all,

I need to do the following

Code:
select ´a´*3 from dual;

The result should be ´aaa´

I´ve tried this

Code:
select to_char(to_number(´a´))*3) from dual;

That doesn´t work correctly.

Anyone can help me?

and what if I need to do:
Code:
select (´name´)*2 from dual;

where the result should be ´namename´

Hope you can help me out.

Thanks,
Kiekster
This post has been answered by Frank Kulash on Oct 22 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2012
Added on Oct 22 2012
6 comments
342 views