Database Reference
In-Depth Information
Figure1-1: The complete Oracle system: Oracle Instance and Oracle
Database. The Oracle Database is basically Genie's area to write
information and to make the changes permanent on the hard disk.
Oracle Instance is something with which users interact in terms
of storing and retrieving information. There are no physical files
like in case of COBOL or MS Access for user~database
interaction. Anything that is going into the database or coming
out of the database has to be through Oracle Instance and to
communicate with Oracle Instance we need to learn Genie's
language: SQL. It stands for Structured Query Language and
pronounced as See-Qual. Just imagine as if Aladdin is from
France and knows only “French” language but when he came to
US he found this magic lamp. When he rubbed the lamp Genie
came out. Now even though Genie wants to help Aladdin and
fulfill his commands but he cannot do anything due to language
barrier. Aladdin has only two options either to teach Genie
“French” or teach himself “English”. As Aladdin is depending
on Genie to gets his commands fulfilled so ethically it's his job
Search WWH ::
Custom Search