Client Tools :: Dynamic Schema Name At Runtime

SRCDEV is my source scehma and TRGDEV is my target schema.

SRCDEV schema table data will be loaded into TRGDEV schema respective tables by applying certain business rules.

After loading SRCDEV tables to TRGDEV tables, i am trying to find eliminated rows in SRCDEV tables due to business rules applied.[requirement].

i am doing it in this way

(SRCDEV.table) minus (TRGDEV.table);

The problem here is my schema name will be changed in every environemnt. for example,

for DEV --> SRCDEV
for TST --> SRCTST
for PRD --> SRCPRD.

so i tried following; but it is not working.

how to solve this?

--SRCDEV SCHEMA -- SRC TABLE

CREATE TABLE SRC (SNO INT, PROD_CD VARCHAR2(100));

INSERT INTO SRC VALUES (1,'SOOO1');
INSERT INTO SRC VALUES (2,'S1OO1');
INSERT INTO SRC VALUES (3,'SO1O1');
INSERT INTO SRC VALUES (4,'SOO11');

[Code]...

IS THIS CORRECT SYNTAX?