Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category


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

why? pls help

Question Posted / kanan

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


Please Help Members By Posting Answers For Below Questions

Write a syntax for update query in oracle?

1073

How to rename an index in oracle?

1169

What is ADDM Advisor in Oracle?

1224

What is the data pump import utility?

1074

How does one get the view definition of fixed views/tables?

1072

Explain what are synonyms used for?

1094

Explain the use of grant option in imp command.

1078

What is Virtual Private Database in Oracle?

1150

How to call a sub procedure?

1147

How view is different from a table?

1081

what is reindexing?

1729

What is bulk copy or bcp in oracle?

1184

What is a tns file?

1042

What happens if you use a wrong connect identifier?

1140

How do I start tns listener?

1096