What steps should a programmer should follow for better tunning of the PL/SQL blocks?Difference between procedure and function?What is the use of ref cursor return type?
If you want to take care of performance tuning you need to take care of sub-queries as they takes a lot of time to executing in side the pl-sql blocks.
Ref cursor is used to declare a pointer variable. When you return a ref cursor, you are returning a pointer variable.
How to return more than one value from a function?What are the types of triggers?What are the features of Oracle 9i
There are five types of Triggers
1) Data Definition Language triggers: These triggers fire when you make changes to the objects in the database like create, update or delete. They can be implemented...
The function always return a SINGLE value, which includes arrays. Check out the table functions (pipelined), BULK_COLLECT, arrays etc... You can find plenty of examples.
Do you like working in a team or alone? Explain.
What do you do when things do not go as planned? Cite an example.
What do you think about our company?
What are the career options available in Software Testing Industry?
Careers and Higher Education Options for BBA Graduates
Tell me about a skill you recently acquired or improved.
BPO Career for BTech Graduates
What will you do when you are not able to get your message across to your audience?
Do you seek advice from others when you have a question?
Career Options for BCA Graduates
Ask Interview Question?
Have Career Question?
Ask Only Career questions.