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 uses of a database trigger?

994

State the various uses of dbcc command?

1060

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2133

What is a database table in oracle?

1023

What is an anonymous block?

1254

How to update values in a table in oracle?

1026

What to do if dba lost the system password?

1172

How to sort output in descending order in oracle?

1045

How to run create database statement?

1034

What are group functions in oracle?

1041

What are the differences between primary key and unique key?

1010

What is an oracle transaction?

1146

Explain the difference between sap and oracle?

1029

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

How to open a cursor variable?

1038