PL/SQL (MOSC)

MOSC Banner

SQL or PL/SQL query to convert the existing table into the one proposed below

edited May 23, 2012 7:46PM in PL/SQL (MOSC) 24 commentsAnswered ✓
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:


Column Name

Type

Max Size

Test_instance_id

NUMBER

20

Option_id

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center