to_char function can take both Number and String Values but one at a time

select to_char('10','10')
from dual
This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL

why? pls help

Question Posted / neha k

6 Answers
20536 Views
I also Faced
E-Mail Answers

Answer Posted / neha k

to_char function can take both Number and String Values but
one at a time.

ie. select to_char(10) from dual;
select to_char('10') from dual;

both are valid.

Another form of overloaded function to_char accepts two
arguments first is Date and second if its format in which
it needs to be converted as string.

ie. select to_char(sysdate,'YYYYMMDD') from dual;

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a nvl function?

955

How to convert characters to numbers in oracle?

997

How to define a variable of a specific record type?

1015

How do I know if oracle client is installed on windows?

951

What is an external table?

956

How to pass a parameter to a cursor in oracle?

1102

WHAT IS ecc 6.0

2099

What is raw datatype in oracle?

1049

What is sharded cluster?

924

What is Trigger in Oracle?

1071

What is a private synonym?

1525

How to create a new tablespace in oracle?

932

How to use "for" statements in oracle?

1016

What are joins, explain all types of joins?

2216

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2243