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
- 20550 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
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is a trace file and how is it created in oracle?
What is the difference between sharding and replication?
What do you mean by group by clause?
Explain view?
What is the database name in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is the relation of a user account and a schema in oracle?
What are the differences between date and timestamp in oracle?
Which environment variables are absolutely critical in order to run the OUI?
How many types of segments in Oracle?
How to put more than 1000 values into an oracle in clause?
What are the different types of synonyms?
Explain the use of control file?
How do you find current date and time in oracle?
