To_char to_number combination
969983Oct 22 2012 — edited Oct 22 2012Hi 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