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 is Reduced List of Values?

1710

How to export your connection information to a file?

601

How can you merge two tables in oracle?

575

What is the parameter mode that can be passed to a procedure?

578

How will you identify oracle database software release?

531

Explain oracle left join with an example?

592

How to define a variable to match a table column data type?

585

Can we commit inside a function in oracle?

564

How to connect to a remote server?

567

What are a query and state the different types of queries and their uses?

518

Whats the benefit of dbms_stats over analyze?

1499

How to pass parameters to procedures?

557

Explain enable novalidate constraint.

601

Explain how you would restore a database using RMAN to Point in Time?

1645

What is the data pump import utility?

590