on 12-18-2017 1:28 PM
1) Changing a column from Sql Server to Oracle using the below mapping rule
varchar(5) -> 2 char cut off ->VARCHAR2 (5 BYTE)
Hi Navya,
Just create target table in oracle with required column data types and load the data.
Cut off after 5 characters --- You can use SUBSTR() function to cut a string.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi navya sinha,
while creating target table, you can specify that column to default null like below and you can also pass NULL in the query transform mapping for this column.
CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int DEFAULT NULL,
City varchar(255) DEFAULT 'Sandnes'
);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.