Handy Annotations within Oracle 10g

This paper describes practical observations during the Database system Lab. Oracle 10g DBMS is used in the data base system lab and performed SQL queries based many concepts like Data Definition Language Commands (DDL), Data Modification Language Commands ((DML), Views, Integrity Constraints, Aggreg...

Full description

Bibliographic Details
Main Authors: Jagli, Mrs. Dhanamma, Gaikwad, Ms. Priyanka, Gunjal, Ms. Shubhangi, Bilaware, Mr. Chaitanya
Format: Text
Language:unknown
Published: 2013
Subjects:
DML
Online Access:http://arxiv.org/abs/1310.2367
Description
Summary:This paper describes practical observations during the Database system Lab. Oracle 10g DBMS is used in the data base system lab and performed SQL queries based many concepts like Data Definition Language Commands (DDL), Data Modification Language Commands ((DML), Views, Integrity Constraints, Aggregate functions, Joins and Abstract type . While performing practical during the lab session, many problems occurred, in order to solve them many text books and websites referred but could not obtain expected help from them. Even though by spending much time in the database labs with Oracle 10g, tried in numerous ways, as a final point expected output is achieved. This paper describes annotations which were experimentally proved in the Database lab. Comment: 5Pages,2Figures