[code_firebug]

The code below inserts 24 rows to my PRICE table, but i need to understand how to fabricate the code to add 135 rows to my price table. If anyone can help, that will be awesome.

SELECT price_s1.NEXTVAL, i.item_id,
(
SELECT cl.common_lookup_id
FROM common_lookup cl
WHERE cl.common_lookup_type = '5-DAY-RENTAL'
),
'N',
CASE
WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date)) > 30 THEN i.release_date
ELSE i.release_date
END,
(
SELECT p.start_date
FROM price p
WHERE p.end_date = p.start_date + 30
),
(
SELECT
CASE
WHEN (TRUNC(SYSDATE) - TRUNC(i.release_date)) > 30 THEN 5
ELSE TO_NUMBER(cl.common_lookup_code)
END
FROM common_lookup cl
WHERE cl.common_lookup_type = '5-DAY-RENTAL'
),
1, TRUNC(SYSDATE),1,TRUNC(SYSDATE)
FROM item i;

[modi123_1]

Again, do not open duplicate topics. You already have one open.