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

Can the query output be sorted by multiple columns in oracle?

972

What are the different types of partitions in oracle?

951

How can I get column names from a table in oracle?

1032

What is the quickest way to fetch the data from a table?

1043

What is difference between truncate and delete?

1018

Explain the different normalization forms?

1055

What is a data lock in oracle?

1080

What is recycle bin in Oracle?

1132

How to define an anonymous procedure with variables?

1127

How to display employee records who gets more salary than the average salary in the department?

1039

What privilege is needed for a user to create indexes in oracle?

1011

What is blob datatype?

1100

How to store only time; not date and time?

1005

How do I find the database name in oracle?

1019

How to shutdown your 10g xe server?

1133