In Table T there are few columns of which 2 columns are
related to Product – Product Code (col A) and Plan Code (col B). Col A contains
only one value at one time per record. However, Col B can contain more than one
Plan code in a single row. The Plan codes are spread across col B which has
length of 500 chars. Also, Plan Code in col B is appears for every first 3
characters of every 18 characters read. E.g aklsjjhvkjwejbivpwepbvvkbvsa….
, akl and epb are 2 plan codes here in the given string of col B.
Please write a SQL script to get DISTINCT values of Product
Code and Plan Code from Table T. For instance if table T has a record
should result in