Open Source Database

ADDING, DELETING AND MODIFYING RECORD         I.                      Adding record       II.                      Deleting record.     III.                    Updating/modifying data values.    IV.                      Saving and undoing change in data.      V.                      Truncate    VI.                     Drop ADDING RECORD:- DBMS is basically collection of data in the form of table with row and columns. The first step is to create a table and adding new record. Inserting values of different data types Character data typ...

                                  ORACLE INDEXES Introduction. Removing index.   Creating index on multiple columns. Types of index. Advantage of index Disadvantage of index.   Data dictionary table for index. ·           ·         Introduction:- Index is an object which can be defined as the order list of value of a column of combination of column used for faster searching and sorting of data. Oracle assign a unique identification number to every record in the database called ROWID. It contain the physical address/location of a record in the database. ROWID is a pseudo-column associated with each and every record of a table and is represented by radix values. To speed up the retrieval of record for job column we will create an index. Where ind_emp_job is user define name ...