Re: trigger help please

Hi Skippy,

There is very old but easy way to copy table from one database to another. It's using COPY command from SQL*Plus.

It is fragment from SQL*Plus documentation:

The following command copies the entire EMP table to a table named WESTEMP.
Note that the tables are located in two different databases. If WESTEMP already
exists, SQL*Plus replaces the table and its contents. The columns in WESTEMP have the same names as the columns in the source table, EMP.

SQL> COPY FROM SCOTT/TIGER_at_HQ TO JOHN/CHROME_at_WEST -> REPLACE WESTEMP ->
USING SELECT * FROM EMP Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

"Skippy" <SkippyNOSPAM_at_hotmail.com> wrote in message news:<an86s2$3mo$1_at_slb7.atl.mindspring.net>...
> I need to some help creating a trigger. I have a table and I need an insert
> trigger when I try to insert something in table 1.. it makes sure that the
> value exists in table 2.. more sepcifically.
>
> Table 2 is a list of courses and pre-requisites for each course.
>
> Table 1 is a registration table. The user should not be able to sign up for
> a course if they have not taken the pre-requistie course
>
> Table 3 has the list of courses that the student has taken.
>
> thanks.
>
> skippy
Received on Mon Sep 30 2002 - 03:04:05 CDT