Re: Verweis auf unbekannte Tabelle?

Sorry, I´ve forgotten that this is an english newsgroup. So, once again in english:

I´d like to save (in a table called X) the ID of rows of currently unknown tables.

I created a structure for table X as following:

FOREIGN_ID number, -- id of the row in the unknown table
FOREIGN_PK varchar2(30), -- name of the table's primary key
FOREIGN_SCHEMA varchar2(30), -- schema name
FOREIGN_TABLE varchar(30) -- table name

Now, how can I select the specified row? I would think of something like this:

select * from
  FOREIGN_SCHEMA.FOREIGN_TABLE a
where
  a.FOREIGN_PK = 'FOREIGN_ID'

In this, all FOREIGN_* values should be evaluated and replaced with the values stored in table X.

Many thanks in advance,
Dirk Received on Sun Feb 02 2003 - 11:40:47 CST