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 merge statement used for?

1005

Explain the difference between replace() and translate() functions in oracle?

1021

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

2168

What are the various types of snapshots ?

1011

How to create a server parameter file?

1118

How are extents allocated to a segment?

1107

can u plz provide me oca sql dumps please i need them

1931

What the is the diff between local index and global index. give some example.

1617

How to select some columns from a table in oracle?

1064

How to define a variable of a specific record type?

1054

Please explain oracle left join with an example?

1020

What is the string concatenation operator in oracle?

1151

How does Oracle guarantee data integrity of data changes?

2370

What happens to the data files if a tablespace is dropped?

1041

Which environment variables are absolutely critical in order to run the OUI?

2104