Migration from Sybase to Oracle

I’m migrating from Sybase to Oracle Database and I have a doubt. When converti-me tables, Timestamp data type in Sybase is converted to Raw or Number data type in Oracle ? I think is Raw but when I use the scratch editor in SQL Developer, it converts to Number.

Thanks in advance.

Oracle DatabaseSybase Database* Database migrationDatabases

Last Comment

slightwv (䄆 Netminder)

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Haris Dulic

5/11/2021

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

slightwv (䄆 Netminder)

5/11/2021

>>When converti-me tables, Timestamp data type in Sybase is converted to Raw or Number data type in Oracle ?

I've never used Sybase but I would hope a timestamp in any database would be converted to a timestamp in Oracle. Always store dates and times in he appropriate data types.

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

Certified Expert Program

Credly Partnership

Udemy Partnership