adding to the above answer to_char function takes only the number value

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

why? pls help

Question Posted / rpk

Answer Posted / rpk

adding to the above answer to_char function takes only the
number value

i.e select to_char(10) from dual;

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain the dml?

1044

Explain alias?

1193

What are joins, explain all types of joins?

2360

Explain the use of control file?

1173

Who developed oracle & when?

1057

What is ceil and floor in oracle?

1119

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2233

Explain the use of constraints option in exp command.

1080

What is Reduced List of Values?

2244

How to view all columns in an existing table?

979

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

Difference between oracle's plus (+) notation and ansi join notation?

1160

What is control file used for?

1300

How can I see all tables in oracle?

1060

WHAT IS ecc 6.0

2202