If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.
If you require dynamic cache i.e where your data will change dynamically then you can go for connceted lookup.If your data is static where your data won't change when the session loads you can go for unconnected lookups
State the difference between implict and explict cursors?
How to know the last executed procedure?
How can a function retun more than one value in oracle with proper example?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the basic structure of PL/SQL?
What are the components of a PL/SQL block?
What are the datatypes a available in PL/SQL?
What are % TYPE and % ROWTYPE? What are the advantages of using these over datatypes?
What is difference between % ROWTYPE and TYPE RECORD?
What will the Output for this Coding> Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
