Hi Sri, Why don't you change the column into number(6,6) so whenever you insert all decimal behind it will keep at it and if you want to only display two decimal, you can do too .
> -----Original Message----- > From: Campano, Troy [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 10:22 PM > To: [EMAIL PROTECTED] > Subject: Re: Database number > > have you tried printing out your INSERT statement to the JSP page and then > copy/paste it into SQLPLUS to run the SQL against just the database. > If you do that then it would be easier to figure out if it's a database > issue or Java issue. > > thanks! > > > Troy Campano > > [:==> Troy Campano <==:] - Roadwarrior on the Information Superhighway > Request Manager/Database/Web > Microsoft gave you Windows, UNIX the whole house. > > -----Original Message----- > From: srinivas tadikonda [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 10:15 AM > To: [EMAIL PROTECTED] > Subject: Database number > > > Hi, > > Please help me the following situation. > > I am tring to insert some data into oracle database. Here one > field datatype is > Number(22,6) > what ever I inserted in this field it will take only (after decimal) > two degits. Actually I want to to be inseterd after decimal 6digits. How > can I solve this. > ex: if I insert : 34567.58587 . > Database shows : 34567.59 but I want exactly what I inserted. > Please help me. > Regards > Srinivas > > > _____ > > Get your FREE download of MSN Explorer at http://explorer.msn.com > <http://go.msn.com/bql/hmtag_itl_EN.asp> > > ========================================================================== > = To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp http://www.jspinsider.com > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
