• Excellent knowledge in (stored procedure, packages, functions, ref cursors, dynamic SQLs etc., dynamic PL/SQL, Sybase DB).
• Basic knowledge in Advanced Oracle features (Table partition, Table functions, experience with Oracle built in utility programs).
• Strong knowledge tuning, Analytic function, ability to convert simple PL/SQL logic into SQL.
• Must have knowledge in DBMS_XMLGEN.
• Must have experience is developing Queries using XMLTABLE, XMLEXTRACT , XMLELEMENT, XMLTYPE.
• Must have experience in developing reports using oracle advance PL/SQL.
• Must have experience in UTL_FILE , DBMS_SQL.
• Must have experience in using Oracle TYPES.
• Strong understanding of Oracle Database in built functions.
• Must have knowledge in Oracle query plan /cost analysis.


Source link