HI Sumaya,
This is the way you have to use dblink. And one more think.
To excute this query you nedd to have dblink functions installed in your
database schema.
select * from dblink('YOUR_DB_LINK_NAME','select * from mytable')as
tmp(column1 datatype,column2 datatype.)
Regards,
R
Hi ,
The query is like this ,
Except
SELECT * from ((SELECT COUNT(id) FROM table1) Except (SELECT COUNT(id)
FROM table2))tmp
Regards,
Ram
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Craig Ringer
Sent: Thursday, May 22, 2008 9:05 PM
To: Nacef LA
