A data warehouse can be thought of as a three-tier system in which a middle system provides usable data in a secure way to end users. On either side of this middle system are the end users and the back-end data stores.
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;
What are the Restrictions on Cursor Variables?
Can we declare a column having number data type and its scale is larger than pricesion ex column_name NUMBER(10,100), column_name NUMBAER(10,-84)
What will happen after commit statement?
Explain the usage of WHERE CURRENT OF clause in cursors?
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
