select to_char('10','10')
from dual
This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL
why? pls help
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 |
Post New Answer View All Answers
Design database draw er diagram for a certain scenario ?
Does oracle partitioning improve performance?
How to get last row id?
Will you be able to store pictures in the database?
How to open a cursor variable?
How to rollback the current transaction in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Difference between the “verify” and “feedback” command?
Difference between oracle's plus (+) notation and ansi join notation?
What is the minimum client footprint required to connect c# to an oracle database?
What is bulk copy or bcp in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to check the server version in oracle?