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!

Generating rows!

908197Jan 9 2012 — edited Jan 11 2012
Hi, here is second part of 2332708

Know i have created another table EXPENSES (person_ID, expense_name, cost) with foreign key(person_ID) from first table PERSONS.

And what i need to do is generate 50 rows for each person, generate expense name from DBMS_RANDOM and generate cost using DBMS_RANDOM as numbers between 1 and 1000. Could anybody help me with this, as i sed i am pretty new to oracle, so i am learning :)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2012
Added on Jan 9 2012
7 comments
113 views