Home » SQL & PL/SQL » SQL & PL/SQL » what is the differnece between MS-access and oracle databases
what is the differnece between MS-access and oracle databases [message #232278] Fri, 20 April 2007 00:23 Go to next message
white
Messages: 13
Registered: October 2006
Junior Member
Hi,

I want to know the what is difference Ms-access database and Orace database.How data is maintained in both the databases,
whether Ms-access comes under Dbms or rbdms?



Thanks in advance,
Re: what is the differnece between MS-access and oracle databases [message #232287 is a reply to message #232278] Fri, 20 April 2007 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
About the same between a liner and a bicycle.

Regards
Michel
Re: what is the differnece between MS-access and oracle databases [message #232301 is a reply to message #232287] Fri, 20 April 2007 01:32 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Read the sticky (tips & tricks). There's a link to an MS Access forum.

MHE
Re: what is the differnece between MS-access and oracle databases [message #232354 is a reply to message #232278] Fri, 20 April 2007 04:26 Go to previous messageGo to next message
kusuma_kkm@yahoo.co.in
Messages: 2
Registered: April 2007
Location: hyd
Junior Member

MS-acess is a purely rdbms.in theis data is organised rows&columns,store in to rows&columns only.but in oracle data is consider as file (colletion of data)internally .where as it display rows&columns
Re: what is the differnece between MS-access and oracle databases [message #232355 is a reply to message #232354] Fri, 20 April 2007 04:29 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
kusuma_kkm@yahoo.co.in wrote on Fri, 20 April 2007 11:26
MS-acess is a purely rdbms.in theis data is organised rows&columns,store in to rows&columns only.but in oracle data is consider as file (colletion of data)internally .where as it display rows&columns

Laughing Right, and you believe that.

MHE
Re: what is the differnece between MS-access and oracle databases [message #232434 is a reply to message #232354] Fri, 20 April 2007 08:53 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
kusuma_kkm@yahoo.co.in wrote on Fri, 20 April 2007 05:26
MS-acess is a purely rdbms.in theis data is organised rows&columns,store in to rows&columns only.but in oracle data is consider as file (colletion of data)internally .where as it display rows&columns


That is pretty much the worst explanation I have ever heard to describe Oracle.
Re: what is the differnece between MS-access and oracle databases [message #232494 is a reply to message #232278] Fri, 20 April 2007 13:31 Go to previous messageGo to next message
smcnulty
Messages: 2
Registered: April 2007
Junior Member
I could tease you and insist that you post versions, but I won't.

Michel's answer is concise and correct. The number of differences is legion.

I suggest you have a look at the Wikipedia articles on the two subjects. Since this sounds like a homework assignment.

http://en.wikipedia.org/wiki/Microsoft_Access

http://en.wikipedia.org/wiki/Oracle_database
Re: what is the differnece between MS-access and oracle databases [message #232566 is a reply to message #232354] Sat, 21 April 2007 04:58 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
kusuma_kkm@yahoo.co.in wrote on Fri, 20 April 2007 12:26
MS-acess is a purely rdbms.in theis data is organised rows&columns,store in to rows&columns only.but in oracle data is consider as file (colletion of data)internally .where as it display rows&columns


And in MS-Access the data is stored NOT in files but obviously in outer space (somewhere near Sirius, if I remember correctly).




[Updated on: Sat, 21 April 2007 04:58]

Report message to a moderator

Re: what is the differnece between MS-access and oracle databases [message #232871 is a reply to message #232278] Mon, 23 April 2007 13:47 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
I have a link to a fairly nice discussion on the differences. It is not for the most current versions, but is very informative. Check the following link.

http://eis.bris.ac.uk/~ccmjs/ora_sql.htm
Previous Topic: Trigger problem??
Next Topic: Table Comparison....
Goto Forum:
  


Current Time: Tue Dec 06 00:15:13 CST 2016

Total time taken to generate the page: 0.05463 seconds