Friday, 8 July 2016

DDL & DML

 DDL & DML DDL-(DATA DEFINITION LANGUAGE) 1.CREATE 2.ALTER      1.ADD      2.MODIFY      3.RENAME      4.DROP These...

SUB QUERY

               SUB QUERY *The Query with in another is query is known as "SUB QUERY". *In Sub query the inner part is execute first and the Outer query will execute second. *Can not use the WHERE condition after the GROUP BY Clause. *Sub query start with...

JOINS

Joins In Oracle        JOIN is used for selecting the data's from one or more tables. TYPES OF JOINS:: 1.EQUI JOIN 2.OUTER JOIN    i)LEFT OUTER JOIN  ...