Re: dynamic sql

On Sep 10, 11:07 am, durga <kanagadurga.sunda..._at_gmail.com> wrote:
> hi folks,
>
> i am an oracle novice....i am working on a small project, i've
> created a few tables holding employee, projects and clients info. My
> parent table is OGEMP whose primary key is SSN, there are 5 other
> tables whose foreign key is SSN(referring OGEMP).
> Here's my problem, if an employee says that his SSN has been entered
> wrong, then I should be able to modify my OGEMP table and insert the
> new SSN and delete the old one. I have to use a bottom-up approach
> here, since there are other tables who have SSN as foreign keys.
> I am supposed to use dynamic SQL for this problem. I got a clue
> here........first I've to create a new table which is going to hold my
> OGEMP and related tables in a particular order (parent to child), then
> insert the new ssn as a new record in the parent table, update in all
> my child tables and finally delete the old SSN from the OGEMP table.
> I've created the new table.........but my problem is inserting rows
> (tables in parent to child order)...........I've to use dynamic SQL
> and user_constriants......help please!!!!

I would expect you to consult your instructor on this. You're paying for such services from him or her; I would want to get my money's worth from that investment. Obviously the topic of dynamic SQL has been covered in class; possibly there are additional resources your instructor can make available to you.
Also there are resouces on the web; you should be using google.com to find them.

To ask for assistance when you haven't provided any sample of the work you've already tried to solve this problem won't get you very far. Helping is one thing; writing your homework for you is entirely another, and you shouldn't expect such 'service'.

Post what you've done to answer this question. We'll help, we just won't do your homework for you.

David Fitzjarrell Received on Mon Sep 10 2007 - 12:40:06 CDT