Write a program in PL/SQL to FETCH multiple records and more than one columns from the same table.
SIKSHAPATH Latest Questions
Why ‘Data Redundancy’ is higher in 1st Normal Form than other normal forms? Explain with example.
Given relation R (A,B,C,D) and the following FD’s. Identify the candidate key for R and highest normal form C->D, C->A, B->C
Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor.
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.
Q.Write a program in PL/SQL to insert records from one table to another.