Handy Annotations within Oracle 10g

Abstract: 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.