Interested to Buy Any Domain ? << Click Here >> for more details...
select to_char('10','10')
from dual
This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL
why? pls help
- 6 Answers
- 20540 Views
- I also Faced
- E-Mail Answers
Answer Posted / kanan
in this query first 10 is value you want to convert to
character and second value is format ;format can
be '9999.99' or '09999.99' but '10' is not valid
format .you should be thorough at the formats used on
to_char before implementing this .To_char can take upto
three parameters .
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain the use of rows option in exp command.
How to create an oracle testing table?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to login to the server without an instance?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How can I create database in oracle?
Explain what are the different type of segments?
What are the different pseudo commands? Explain in general?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is pragma autonomous transaction in oracle?
How to display employee records who gets more salary than the average salary in the department?
How to start an oracle instance?
How to count duplicated values in a column in oracle?
What is a trigger and what are its types?
