Database Reference
In-Depth Information
except that it's the web version of SQL*Plus. It can be accessed
with a URL having following pattern
http://machine_name:5560/isqlplus
Before accessing this URL, execute the following command
which will start the iSQL*Plus application server.
isqlplusctl start
What is RDBMS?
I would like to discuss over here are few important concepts
about RDBMS (or Relational Database Management System).
There is a long old history about “RDBMS standard” but it all
started with Dr. E.F. Codd in 1969. Making a long story short
there are lot other databases beside Oracle that claim to be
RDBMS (e.g. MS SQL Server, MS Access, MySQL etc). If I
want to create my own database product named “Takveen” and I
have big solid team of programmers; we all first have to read and
understand that RDBMS standard and then we can start writing
the code otherwise we cannot claim in the market that it's a
RDBMS database.
Once you see a RDBMS database product it means it uses SQL
as a language and data inside it is written always in table form
(i.e. rows/records & columns/fields). Moreover, there may or
may not be relationship in-between those tables. The way I
categorize the RDBMS database products (available in the
market keeping in mind their strength to handle data & handle
concurrent user requests) is as follows.
Small Companies :: MS Access
Mid Size Companies :: MS SQL Server
Large Organization/Enterprise :: Oracle
Each of the RDBMS Database manufacture has their own
version of SQL. But they all are more than 90% alike. If it takes
you to learn Oracle SQL in a week, after that you can learn SQL
Search WWH ::




Custom Search