Hi,
I also used fox database, ACCESS, SQL Server, and Oracle for more than
7 years.
In fact , they are similar in some way (RDBMS). Oracle is more
powerful.
for example:

Select * from DB_Link.username.Table1;

CJM 寫道：

> I'm usually developing with SQL Server, but our organisation is in the
>>
> Secondly (and more practically), I need to know how to create my separate
> 'database', and how I can refer to tables & views in the ERP system. In SQL
> this is fairly easy to do - if my application wants to manipulate a tablein
> a different DB I simply use the following type of reference: Select * from
> OtherDB.dbo.Table1. I assume there is an Oracle equivalent.
>>