Methods of SQL Traversal string

String traversal:

1. Create a table--temp that only has an increment sequence (1...N) andperform a Cartesian operation with the table SRC where the target string resides . ( the number of records in the Temp table is either less than the length of the traversed target string)

2. filter out rows with a sequence value greater than the string length.

3. Traverse using the substr () built-in function.

The table structure is as follows:

Temp SRC

ID ID Name Other

1 1 Paul KKK

2

3

4

5

6

7

8

The Traverse results View is:

A

P

A

U

L

1     Select substr (S.name,iter.pos,1) A,2from           (select  Fromwhere=  ' Paul ') s,3              (select from Temp ) ITER4     where<= Length (s.name)

Methods of SQL Traversal string