Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

 

 

 

1- How to select RIGHT TOOL FOR DATA

An Oracle Database a collection of data to store and retrieve related information manages a large amount of data in a multi user environment so that many users can concurrently access the same data and prevents unauthorized access. For example when you construct a house, you have different rooms built as kitchen, hall, bed-room, living-room, dining-room, pooJa and  toilets etc. Entire collection of rooms under the name of house can be called as database and every room can be called as obJects and each obJect serves different nature.

 

 

SQL (pronounced SEQUEL) is the programming language that defines and manipulates the database. SQL databases are relational databases, which mean that data is stored in a set of simple relations. An access to living room from kitchen and bed-room has got some relational entry without losing its main obJects and identity