My input data is csv file like this with '|' delimiter:
1|first
2|second
3|third
4|fourth
5|fifth

I need to load this into temp table for validation purposes...so I did
this:

with T (ID) as ( values '1|first','2|second','3|third','4|fourth','5|
fifth')
select substr(ID, 1,locate('|', ID)-1) as FIRST_COLUMN,
substr(ID, locate('|', ID)+1, length(ID)-locate('|', ID)) as
SECOND_COLUMN
from T

Is there better approach?
What is syntax for having more than one column in "with" clause, eg:
with T (ID, DESC) as ( values '1','2','3','4','5')
select ID, DESC from T -- where should I put DESC
('first','second','third','fourth','fifth') in "values" clause?

On Oct 2, 1:19 pm, "annecarterfr... (AT) gmail (DOT) com"
<annecarterfr... (AT) gmail (DOT) com> wrote:
I got it..I can use "values ('1','first')" in my query..

On Oct 2, 7:19 pm, "annecarterfr... (AT) gmail (DOT) com"
<annecarterfr... (AT) gmail (DOT) com> wrote:
import from f.csv of del modified by coldel0x7C insert into T

/Lennart