Naresh Technologies Oracle Material Pdf

broken image

These files are also called as Flat Files. 1) Books & Papers 2) Flat files 3) Database FLAT FILES: This is a traditional mechanism which is used to store data or information in individual unrelated files. DATA STORE: It is a place where we can store data or information. In the above example, there is meaningful data which is in table format which consist of three different fields. INFORMATION: It is a collection of meaningful data or processed data. Example: 101 dineshġ02 mahesh 3000 In above example, there no meaningful data such data is known as Raw facts. All organizations store same type of data. If you want to operate ORACLE then we are using following languages: 1) SQL: It is non-procedural language. They are: 1) SQL (STRUCTURED QUERY LANGUAGE) 2) PL/SQL (PROCEDURAL LANGUAGE extension of SQL) 3) Dynamic SQL.(optional) ORACLE is a Relational Database product which is used to store data permanently in secondary storage devices. ORACLE 11G(grid) Data: There are mainly two different types of database language is ORACLE.

broken image

Written By Saket Ø Please Send your Suggestions at – Ø Mail me latest notes of other subjects. Oracle 11g Notes of Murali (Naresh Technology) Hyderabad