➢ Write complex queries for accessing information from database.➢ Well Acquainted with oracle base technologies like SQL and PLSQL.➢ Well Versed With:➢ Good knowledge of SQL Statement DDL, DML, DCL, TCL.➢ Good knowledge of SQL queries JOINS (Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross -Join, Self-Join)➢ Good knowledge of SQL queries with single row function and multiplerow function, Like Character, Date Conversion, General and Number.➢… Show more ➢ Write complex queries for accessing information from database.➢ Well Acquainted with oracle base technologies like SQL and PLSQL.➢ Well Versed With:➢ Good knowledge of SQL Statement DDL, DML, DCL, TCL.➢ Good knowledge of SQL queries JOINS (Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross -Join, Self-Join)➢ Good knowledge of SQL queries with single row function and multiplerow function, Like Character, Date Conversion, General and Number.➢ SubQuery, Aggregate Function.➢ Having Good knowledge of where clause, having clause, group by and order by clause.➢ Good Knowledge of data dictionary view.➢ Good knowledge of SQL Constraint Like Primary Key, Foreign Key, Unique key, Not Null, Check.➢ Good knowledge of SQL Schema Object such as Table, View, Sequence, Synonym, Index.➢ Good knowledge of SQL Set Operator Such as Union, Union All, Intersect and minus.➢ Good Knowledge of Basic PLSQL. Show less