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...
AIM: To write a C++ program for string manipulation using dynamic constructors. ALGORITHM: STEP 1: Start the program. STEP 2: Declare the data members and member functions. STEP 3: Define the...
AIM: To write a C++ program for maintaining bank account using constructor overloading. ALGORITHM: STEP 1: Start the program. STEP 2: Declare the data members and constructors. STEP 3: Define the...
AIM: To write a C++ program to perform arithmetic operation using inline function. ALGORITHM: STEP 1: Start the program. STEP 2: Declare and define inline functions ie. ‘add()’,’sub()’,’mul()’,’div()’. STEP 3: Assign...
AIM: To write a C++ program using static data member and static member function. ALGORITHM: STEP 1: Start the program. STEP 2: Declare static variable ‘count’. STEP 3: Define static variable...