Oracle Pl-Sql Developer

Talpro
  • Bangalore
  • 10-15 lakh
  • 8-10 years
  • Views
  • 12 Dec 2016

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- Must be able to read stored procedures, functions, and triggers written in Hana and convert to their Oracle equivalent Triggers

- Must understand when to utilize BEFORE and AFTER triggers

- Must be able to write multi-action triggers

- Must know when to use statement triggers vs row triggers

- Must know when to utilize the WHEN clause

- Must know when to utilize the OF clause

- Must know when to utilize the FOLLOWS clause

- Must understand the use of PRAGMA AUTONOMOUS_TRANSACTION

- Must understand what a mutating trigger is, what causes it, and how it is corrected

- Nice to have would be the ability to write a compound trigger

- Procedures and Functions

- Must be able to build PL/SQL packages from what in Hana were separate objects

- Must understand the PL/SQL package initialization section

- Must understand when and how to use global variables and types rather than local variables and types

- Must understand when and how to utilize constants rather than variables

- Must understand overloading

- Must understand the use of PRAGMA SERIALLY_REUSABLE

- Must be fluent in array processing with BULK COLLECT, FORALL, and the LIMIT and SAVE EXCEPTION clauses

- Must be able to write dynamic SQL utilizing the DBMS_ASSERT built-in package

- Must know how to use the Oracle Database Wrap utility

- Nice to have would be the ability to profile their code with DBMS_PROFILER and/or DBMS_HPROF or another native Oracle database tool


Competencies/Skill sets for this job

Triggers Oracle Pl-sql Processing Utility Oracle Database

Job Posted By

About Organisation

Talpro