Skip to Main Content

Oracle Database Discussions

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!

How to convert BIGINT of MySql to Oracle data type?

176857May 7 2007 — edited May 7 2007
Hi all,

I am new in Oracle, and need to convert Mysql db to Oracle. Now I want to convert table primary key in Bigint of Mysql to Oracle data type. I asked my Oracle friends, one said convert to Number without precision, but the other said it is better to convert to Number with precision. I am confused. Anybody can give me help? I really appreciate it. Thank you very much in advance.

Gus
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2007
Added on May 7 2007
1 comment
666 views