We can use TO_CHAR function in two ways. 1. To convert a number into a cha

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

why? pls help

Question Posted / kumar

6 Answers
21116 Views
I also Faced
E-Mail Answers

Answer Posted / kumar

We can use TO_CHAR function in two ways.
1. To convert a number into a character.
TO_CHAR(-) will take one parameter i.e, number
2. To convert a date into a character.
TO_CHAR(-,-) will take two parameters
i) first parameter is the date
ii) Second parameter is format in which we have to
convert, that to the second parameter should be enclosed
with single Quotes.

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is there a combination of "like" and "in" in sql?

1116

What is blob data type in oracle?

1209

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1094

What is Undo Management Advisor in Oracle?

1154

What is a private synonym?

1647

Please explain joins in oracle?

1107

how to handle exceptions in post production

1486

How a tablespace is related to data files?

1167

Why is oracle database so popular?

1074

What are the arithmetic operations?

1152

what are bitmap indexes? How does they work?

2306

How to use "while" statements in oracle?

1379

what is the dual table in oracle?

1040

What is transport network substrate (tns) in oracle?

1095

How to change user password in oracle?

1099