SQL or PL/SQL query to convert the existing table into the one proposed below
I want to do table migration. here with the details...
1. Script to convert the existing TEST_INFO_TAG table into the one proposed below.
2. Script to migrate data from TEST_INFO_TAG table into the one proposed below.
3. Script to validate if migration has happened properly.
existing table:
select * from INFO_TAG
===================== =====================
"Info_tag_id", "info_tag_name", " Display_name"
===================== =====================
1000 job-id Job ID
1001 operator-id Operator ID
1002 customer-name Customer Name
1003 contractor-name Contractor Name
1004 comment Comment
1005 file-name File Name
row data need to set as column in proposed table.
proposed table:
1. Script to convert the existing TEST_INFO_TAG table into the one proposed below.
2. Script to migrate data from TEST_INFO_TAG table into the one proposed below.
3. Script to validate if migration has happened properly.
existing table:
select * from INFO_TAG
===================== =====================
"Info_tag_id", "info_tag_name", " Display_name"
===================== =====================
1000 job-id Job ID
1001 operator-id Operator ID
1002 customer-name Customer Name
1003 contractor-name Contractor Name
1004 comment Comment
1005 file-name File Name
row data need to set as column in proposed table.
proposed table:
Column Name |
Type |
Max Size |
Test_instance_id |
NUMBER |
20 |
Option_id |
1