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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

John Stegeman
There is some specific capability regarding the back button and task flows http://download.oracle.com/docs/cd/E17904_01/web.1111/b31974/taskflows_complex.htm#BABBEECE

However, since you don't give any information about the NPE you're getting - we cannot say much else.

John
vinod_t_krishnan
chk this aswell added to what john posted
http://download.oracle.com/docs/cd/E17904_01/web.1111/b31974/web_form.htm#CFHHJGJH
1 - 2
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,802 views