![]() ![]() ![]() |
Ispirer SQLWays Database Migration Software
Conversion of Oracle %TYPE to Microsoft SQL Server
The Oracle %TYPE attribute adapts code as table definitions change. The %TYPE attribute provides the datatype of a variable or database column. If the column's type changes, your variable uses the correct type at run time. This provides data independence and reduces maintenance costs.
Microsoft SQL Server does not support and has no an equivalent of Oracle %TYPE.
SQLWays changes Oracle variable declaration with the %TYPE attribute to the Microsoft SQL Server variable declaration with the same data type as column's data type in the database table or as variable's data type.
Examples of the conversion:
Remarks: in the table ora_rt there is column: Name of VARCHAR2(10).
![]() ![]() ![]() |