Please comment The below is what mean?
Select * From The (select Cast (FC_Str2OrderTab3 (' 7690002067 ', ', ')
As OrderListTable) Fromdual)

CodePudding user response:

http://www.itpub.net/forum.php? Mod=viewthread& Page=1 & amp; Tid=1911150

CodePudding user response:

 
- THE rare syntax, it is recommended to use THE TABLE 
Write you a example 
 -SQL> 
SQL> The create type t_type as table of varchar (30); 
2/
Type created 
SQL> Select * from table (t_type (' 123 ', 'XXX', 'uuu', 'peoe', 'China')); 
COLUMN_VALUE 
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 
123 
XXX 
Uuu 
Peoe 
China 
SQL> Drop type t_type; 
Type dropped 

SQL>