To_char function accepts only 1 parameter. So the syntax should be as fo

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

why? pls help

Question Posted / avinash

Answer Posted / avinash

To_char function accepts only 1 parameter.

So the syntax should be as follows.

select TO_CHAR(10) from dual;

Is This Answer Correct ?

16 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are the types of trigger in oracle?

913

Why does for update in oracle 8 cause an ora-01002 error?

932

What is meant by a deadlock situation?

1049

What happens to the current transaction if the session is killed?

925

Explain implicit cursor.

960

What do you mean by merge in oracle?

937

What is a sub query? Describe its types?

963

How to use regular expression in pattern match conditions in oracle?

975

What do you mean by merge in oracle and how can we merge two tables?

1001

defination of bitmap index

2044

Is it possible to insert comments into sql statements return in the data model editor ?

2510

How to specify default values in insert statement using oracle?

1034

What are the roles of dba?

1018

Explain oracle’s system global area (sga).

1074

Explain oracle left join with an example?

954