-
how to do select.. into (or maybe insert...into)?
I have 2 tables --
table1(my_rowid integer, col2 anything)
table2(my_rowid integer)
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)
SELECT my_rowid/69
FROM table1;
Jeff Hunter
-
Hi Elaine
How about using the inbuild substr function ? and doing somethin like this
insert into table2
select substr(col1,1,2),col2 from tabl1
regards
Hrishy
P.S:Hope i understood your question right
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|