What is the difference between a procedure and a function in PL/SQL? How do you declare a variable in PL/SQL? What is a PL/SQL block, and what are its components? What are cursors in PL/SQL, and what are the types of cursors? How do you declare an explicit cursor in PL/SQL? What are triggers in PL/SQL, and how do they work? How do you handle exceptions in PL/SQL?
They are asking about my work experience and technical questions
Triggers
Unix cmds SQL PLSQL queries
There are two table. In one table I have values 1,1,1 and t2 table have 1,1,null. If I inner join what is the count? (How can we tell the count?we can tell the values it can return) 2)what is ref cursor 3) query to delete duplicates. I told him partition by query and his reply was this is very time consuming. Tell me something different. 4)components of cursor.
Write the query to get average minimum and maximum of employee partition by department
What is Mutating table error? When did you get it? How to handle?
Questions on View,mview Collections Triggers Agile methodology
Basic SQL and plsql questions
Basics of plsql and advanced concepts
Viewing 171 - 180 interview questions