| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> FW: use triggers to enforce interigity
-----Original Message-----
From: Saleem, Naeem
Sent: 07 December 1999 14:58
To: 'kogorman_at_pacbell.net'; 'alanshein_at_erols.com'
Cc: 'jingyan.xu_at_tst2000.com'
Subject: RE: use triggers to enforce interigity
Guys,
GET A LIFE! Solving problems like this is all about initiative, i.e. using all resources available.
Jingyan is not asking you to do his home work but merely asking for some help on a specific problem.....having first made a very good attempt at it himself.
In just the same way as we would post a problem on the usergroup....it does not mean that we are getting someone else to do our work for us......
He is not going to learn any less by us helping/guiding him with this problem.
I say good luck to him for showing resourcefulness and application.
Jingyan,
I would be more then happy to try and guide you in the right direction...if you can explain to me the exact error you have......from what I have seen of your code so far it appears to me that you may have some unhandled exceptions and hence you will need to cater for these with "When others" or "When no_data_found".....
Regards,
Naeem
-----Original Message-----
From: Alan Shein [mailto:alanshein_at_erols.com]
Sent: 29 November 1999 19:51
To: comp.databases.oracle.misc_at_list.deja.com
Subject: Re: use triggers to enforce interigity
Message from the Deja.com forum:
comp.databases.oracle.misc
Your subscription is set to individual email delivery
Exactly.
If _you_ can figure everything out _you_ will be an expert. So, start figuring. The longest journey begins with but a single step. Give a man a fish and he eats for a day, teach a man to fish and he eats always.
We've all been there (learning by "fire"), and even without mentioning that a particular problem is a homework assignment, we can usually spot them.
General advice- usually, the assignment is closely related to what was just taught or read, so it is often easy to refer back to the most recent classroom examples or book examples to find a similar problem that merely needs some additional thought and modification. Your professor is not going to give you something you can't do alone. Also, don't be afraid to ask the professor for help. They are usually happy to offer a hint if you can show you thought about it and are stuck. If the professor does not wish to offer a hint, it is often because the problem is easier than you thought (which is a hint in itself), or you haven't thought about it enough. I suspect that if you first try to solve it, and still need help, you could post your _work_ here and get some advice to steer you in the right direction.
And to twist another saying...
May you have interesting assignments.
Jingyan <jingyan.xu_at_tst2000.com> wrote in message
news:smA04.1696$LK3.65291_at_nuq-read.news.verio.net...
> If I can figure everything out, I will be an expert, not a student.
> Jingyan
>
> Kevin O'Gorman wrote in message
> <3841D1E7.BE0B3248_at_trixie.kosman.via.ayuda.com>...
> >Jingyan wrote:
> >>
> >> Hi,
> >> My homework assignment is to use triggers to enforce integrity.
> >> I have student(student_id, student_name),
course(course_id,course_title),
> >> and studentCourse(student_id, course_id) tables. each table has a
> trigger.
> >> in the trigger of student table, when the student_id is updated, the
same
> >> student_id in studentCourse is updated too. the trigger in
studentCourse
> >> check if new student_id that will be set in the studentCourse has
exist
> in
> >> the student table. if not, the trigger will be raise a error and give
up
> the
> >> updating.
> >> But when I update the student_id of student table, I got error. I guess
I
> >> should not use my approach to enforce integrity. How to enforce them?
> >>
> >> Thank a lot,
> >>
> >> Jingyan Xu
> >
> >I hope nobody needs reminding not to do someone else's homework. This
> >student
> >will learn more by thinking it through.
> >
> >
> >--
> >Kevin O'Gorman (805) 650-6274 kogorman_at_pacbell.net
> >At school: kogorman_at_cs.ucsb.edu
> >Permanent e-mail forwarder: Kevin.O'Gorman.64_at_Alum.Dartmouth.org
>
>
This email is confidential and should not be used by anyone who is not an original intended recipient. If you receive this communication in error, please email csr_at_ppm-uk.com. Prudential cannot accept liability for statements made which are clearly the sender's own and are not made on behalf of Prudential. No statement shall be construed as giving investment advice outside the UK.
Sent via Deja.com http://www.deja.com/ Before you buy. Received on Tue Dec 07 1999 - 09:07:56 CST
 |
 |