ORACLE SQL Hello I need help with the following questions: 2. If you are transla

Question

ORACLE SQL

Hello I need help with the following questions:

2. If you are translating a CREATE script that was used to create a table in a MS SQL Server environment, what is the closest data type specification you can use in Oracle instead of Microsoft’s INTEGER data type? By closest, consider how many different integer values are available when you declare the type as INTEGER in MS SQL Server. Then figure out the precision/scale combination for NUMBER that will give you at least as many possible numbers and the fewest more possible numbers.

Explanation / Answer

The closest data type specification in oracle instead of INTEGER datatype in ms sql server is INT datatype in oracle. Because the range of both INTEGER in ms sql server and the INT in Oracle is same. So I would use int datatype in oracle.

In ms sql server we have different integer values or types will be available those are smallint , tinyint,bigint and int.

The precision/scale combination for Number datatype have the highest posibile numbers of range precision as 38 and scale as 127. The least possible value range for precision is 1 and the scale is -84 for the number datatype.

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.