Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [?] Command USE using Oracle db

Re: [?] Command USE using Oracle db

From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Mon, 06 Oct 2003 13:15:37 GMT
Message-ID: <ZVdgb.509567$cF.181415@rwcrnsc53>


Perhaps you should work with databases that have been around longer. Except for dbase and Foxpro, which are file based, and not RDBMS, the rest are relatively new. A database in Oracle is a collection of tables, views, etc. In Oracle, and I think DB2, there is also a concept of owner. Which is a schema.
You should read the docs because not all databases work the same. (The ones on your list don't work the same do they? No.) Jim

"Igor Damiani" <igor_at_igordamiani.it> wrote in message news:blrbrn$fc4au$1_at_ID-134521.news.uni-berlin.de...
> sorry, but i use dBase, FoxPro, Access, MS-SQL Server and Mysql....
> Oracle is the only RDBMS that use particular terms and concept to identify
> database and table and so on.
>
> database is a collection of tables, views/queries, users in every RDBMS I
> have worked on.
> Why Oracle call it "schema" ?
> :-/
> IMHO, Oracle have to align his semantics to all other todays' RDBMS .....
> thanks, that's all!
> good coding!!!
> --
> Damiani Liborio Igor
> http://www.igordamiani.it
> Nella finestra Debug di VB:
> Nome="igor":? Nome & Chr$(64) & Nome & "damiani" & Chr$(46) & "it"
> Che tu sia maledetto, SWEN...
>
>
Received on Mon Oct 06 2003 - 08:15:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US