Re: Noob Oracle Question

From: dbsrvc <transeading_at_gmail.com>
Date: 17 Aug 2006 07:26:56 -0700
Message-ID: <1155824816.458451.53710@75g2000cwc.googlegroups.com>

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 table in
> a different DB I simply use the following type of reference: Select * from
> OtherDB.dbo.Table1. I assume there is an Oracle equivalent.
>> Received on Thu Aug 17 2006 - 09:26:56 CDT