Skip to Main Content

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!

sql statement

gonzromanMar 30 2010 — edited Apr 1 2010
I would like to create records based on column FROM/TO number using a SQL statement.

Below is a sample table:

Table A has 2 columns (col1 and col2 as number).

COL1 value=1 and COL2 value=5.

I want to insert 5 records in a table from the value of col1 and col2 using SQL. I can do it in PL/SQL but I can't in a single SQL statement. Below is the sample # of records that should be created in the table.

rec1
rec2
rec3
rec4
rec5

Appreciate any help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2010
Added on Mar 30 2010
12 comments
1,840 views