what is nvl; what is substring; what is joins, what is pseudocolumn, what is cursor, how to get the dense rank for table.
Oracle Plsql Developer Interview Questions
171 oracle plsql developer interview questions shared by candidates
Basic SQL ans PLSQL concepts
types of subqueries? and difference between them? types of triggers? types of trigger? write a trigger which will using do insert, update and delete on 'employee' table and keep audit in 'audit' table. if inserting insert into table also in audit table if deleting delete from also insert in audit table if upadte is require then update table and this update entry should insert in audit table types of cursors and create procedure take cursor and display emp name and salary.? what is database name? database structure you use to create database objects?
You have experience in performance tuning?
they tested my coding knowledge
Basic question - why we use pkgs, fun procedure,joins, triggers,
Views, collection, performance tuning
Tell us about your current role
Store Procedure,Curse,package.
What is difference between row cursor and select cursor
Viewing 51 - 60 interview questions