Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: aliases and links

Re: aliases and links

From: Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de>
Date: 1998/05/08
Message-ID: <3552B0BA.68EBE62F@bitoek.uni-bayreuth.de>#1/1

Mark G. Woodruff wrote:

> I have a table containing a list of databases. When someone adds a
> record to
> the table (via SQL INSERT through JDBC), I'd like to automatically add
> an
> appropriate link and alias for that database using Oracle 7.3.4.
>
> Any suggestions on how to do it?

You could create a aftter insert trigger on this table which executes a create databaselink with the available data!

Hope this helps.

Helmut Received on Fri May 08 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US