DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Omiting 0 from the starting string when inserting data

859474May 30 2011 — edited Jun 8 2011

Hi all,

I have a column whose datatype is varchar2. the columns histogram is "Frequency".

When I insert a record through my DAO code written in JDBC, oracle omits 0 from the starting of the string. e.g.,

Input value is 0023564.
values after inserting is 23564.

I have some doubts over histogram. I didn't set this. I dont know how oracle set histogram and how to remove it?

Any help would be appriciable.

Regards,
Ali

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2011

Added on May 30 2011

#odbc, #windows-and-net

1 comment

159 views