aussiebad.blogg.se - Tableplus oracle

Worked extensively on Ref Cursor, External Tables, Collections (Nested Tables and Varray) in complex backend packages.Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.Proficiency in using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader.Good understanding of star/snowflake schema design.

Involved in designing data migration process flow using Microsoft visio.

Over 8 years of experience with expertise as Oracle PL/SQL Developer in areas of application software development and maintenance in oracle environment using client/server.