Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we create a temporary table with hard-coded values within a query.

466353Nov 7 2005 — edited Nov 8 2005
with temp(col1,col2) as
(values (10,11),(20,21))
select * from temp

The above SQL will display two rows in DB2 (10,11 and 20,21).
We could also use this in a SQL join in DB2.

Is there anything similiar in Oracle.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2005
Added on Nov 7 2005
2 comments
3,689 views