how to convert oracle query to db2 query?

Question

hi am new to DB2 can anyone please tel me how to convert below oracle query into DB2 query, insert into EMPTABLE values((select name from emp),20,'Shankar');

Clockwork-Muse · Accepted Answer · 2011-12-02 23:45:57Z

1

This query works neither on oracle nor db2. I would try something like:

INSERT INTO EmpTable (col1, col2, col3)
SELECT name, 20, 'Shankar'
FROM Emp

edited Dec 2, 2011 at 23:45

Clockwork-Muse

13.2k6 gold badges33 silver badges50 bronze badges

answered Dec 2, 2011 at 7:02

steve

6,0301 gold badge23 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to convert oracle query to db2 query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related