Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor.
SIKSHAPATH Latest Questions
Write a PL/SQL block to display the last name of manager, and their departments for a particular city, using parameters with a default value in explicit cursor.
Draw the queue structure in each case when the following operations are performed on an empty queue. (a) Add A, B, C, D, E, F (b) Delete two letters (c) Add G (d) Add H (e) Delete four letters (f) Add I
Reverse the order of elements on stack S a. using two additional stacks b. using one additional queue c. using one additional stack and some additional non-array variables
Q.Write a program in PL/SQL to insert records from one table to another.
Write a program in PL/SQL to print the value of a variable inside and outside a loop using LOOPEXIT statement.