EX.NO: 4.d CREATION OF INDEXES
Aim: To create the indexes on the attributes for fast retrieval of records. Description Indexes are special lookup tables that the database search engine can use to speed up data retrieval. An index helps speed...
Aim: To create the indexes on the attributes for fast retrieval of records. Description Indexes are special lookup tables that the database search engine can use to speed up data retrieval. An index helps speed...
Aim : To create and use the sequences for auto-numbering. Description: The Oracle SEQUENCE function allows you to create auto-numbering fields by using sequences. An Oracle sequence is an object that is used to generate...
Aim: To create and execute the savepoint and rollback commands. Description Savepoint: savepoint marks and saves the current point in the processing of a transaction. When a savepoint is used with a rollback statement, parts...
Aim: To create an updatable view and read only view on different tables. PROCEDURE * A view created using already existing table. * If there is any updation or insertion is performed in existing table,the...
AIM To work on various constraints in DBMS CONSTRAINTS Constraints are part of the table definition that limits and restriction on the value entered into its columns. TYPES OF CONSTRAINTS: 1) Primary key 2) Foreign...
Aim: To perform insertion, deletion, modification of records based on some conditions and to execute the DCL and TCL commands Insert command: Insert command is used to insert single or multiple rows in the table....
Aim: To execute the queries to create and alter the schema of the database. Data Definition in SQL Creating Tables: The SQL command for creating an empty table has the following form: Syntax: create table...
The prerequisites of the lab are: 1. Oracle-Sql 2. Visual Basic 6.0 SQL: In relational database systems (DBS) data are represented using tables (relations). A query issued against the DBS also...