Oracle PL SQL Developer

Apptad Inc

Job Location:

Tampa, FL - USA

Monthly Salary: Not Disclosed

Posted on: 8 days ago

Vacancies: 1 Vacancy

Job Summary

Job Description

Strong understanding between OLTP and Batch Processing using SQL and PLSQL

Oracle Table Indexs all types Primary Key

Oracle Table Partitions Fetch JSON data using PIVOT unknown number of columns applying rowlocks using SELECT

Strong written knowledge on SQL Joins PLSQL collections Deterministic function good understanding on sys ref cursor

How to capture which program is calling Oracle PLSQL Procedure function packages

Strong on Oracle SQL parsing SQL engine vs PLSQL engine PLSQL cursors To Date to timestamp Renaming table columns

Very Good understanding of SQL execution plan inline functions

Best approaches on implementing user defined referential constraint check using PLSQL

Comparing data between two identical tables and finding list of columns with unmatched values fastest method on storing and retrieval of JSON data from CLOB columns why should be use Execute Immediate Oracle PLSQL exceptions user defined as well Oracle provided

PLSQL cursor Multiple ways to pass data from Oracle PLSQL procedure to Angular or Java or Python SQL operator in any ALL

Advantage and disadvantage of using PLSQL packages good understanding on Transaction within another Transaction in Oracle

Karat Industry certification in Oracle Database

Skills

Mandatory Skills : Oracle PL/SQL

Job Description Strong understanding between OLTP and Batch Processing using SQL and PLSQL Oracle Table Indexs all types Primary Key Oracle Table Partitions Fetch JSON data using PIVOT unknown number of columns applying rowlocks using SELECT Strong written knowledge on SQL Joins PLSQL collections...