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
- 20849 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
What is an oracle recycle bin?
What is connection pool in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How to login to the server without an instance?
How to create lov dynamically at runtime & attach to text field?
How to turn on or off recycle bin for the instance?
Can we store images in oracle database?
Design database draw er diagram for a certain scenario ?
What is sequence?
What is background process in Oracle?
How to drop an existing view in oracle?
What is meant by an index?
What is merge statement used for?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
