Home » SQL & PL/SQL » SQL & PL/SQL » Datatype Conversion
Datatype Conversion [message #185758] Thu, 03 August 2006 07:53 Go to next message
Debanjan_chat
Messages: 16
Registered: August 2006
Junior Member
Hi Experts,

I have a requirement of converting a couple of SQL Server tables into Oracle, ie create new tables in Oracle having the same table name, column names and datatypes as in SQL Server.

But certain datatypes in SQL Server are not present in Oracle. Can anyone let me know if there is any standard conversion function/routine provided by Oracle for such datatype conversions?

Regards.
Re: Datatype Conversion [message #185761 is a reply to message #185758] Thu, 03 August 2006 07:58 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Quote:

provided by Oracle for such datatype conversions?


OK I'll bite.

WHAT DATATYPE CONVERSIONS????????
Re: Datatype Conversion [message #185794 is a reply to message #185761] Thu, 03 August 2006 11:57 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This document deals with Oracle -> MS SQL Server migration, but covers some details which could, perhaps, help you. There are certain scripts (for example, CREATE TABLE) written in both SQL's so that you could compare them.

Also, when scrollbar reaches approximately 4 cm from the top of the screen Very Happy, you'll find "Data Types" section which might also be helpful.
Re: Datatype Conversion [message #186318 is a reply to message #185758] Mon, 07 August 2006 08:13 Go to previous message
Debanjan_chat
Messages: 16
Registered: August 2006
Junior Member
Thanks Guys. Will let you know if that helps.
Previous Topic: Insert New Line in Database Trigger
Next Topic: How Many columns can we create in oracle 9i table?
Goto Forum:
  


Current Time: Fri Dec 02 14:11:14 CST 2016

Total time taken to generate the page: 0.06681 seconds