how to do select.. into (or maybe insert...into)?
I have 2 tables --
table1(my_rowid integer, col2 anything)
I'd like to copy part of my_rowID from table1 to table2, how can I do that? Do I have to use a cursor for loop? Or I can use select...into or insert...into? I tried a few ways but got no luck
Thank you and have a nice weekend!
perhaps you should write in pseudo-code what you want
INSERT INTO table2(my_rowid)
How about using the inbuild substr function ? and doing somethin like this
insert into table2
select substr(col1,1,2),col2 from tabl1
P.S:Hope i understood your question right
Click Here to Expand Forum to Full Width