When I import the data from .xls file to oracle DB i am facing the following problem.You are suggested to post @ SQL Developer (Not for general SQL/PLSQL questions) so you post in wrong place. How ever,
In .xls file the values in a column are 10.67,19.96,15.36......
at the time of importing it from oracle sql developer i am getting 11,20,15....in the DB
Could any one suggest me what i can do to get the exact data
DEPT_ID NUMBER(10,0) -- don't support decimal.
Hope this helps
DEPT_ID NUMBER(10,6) -- support decimal.