Write a PL/SQL procedure for selecting some records from the database – InterviewSolution

InterviewSolution

1.	Write a PL/SQL procedure for selecting some records from the database using some parameters as filters.
Answer» Consider that we are FETCHING details of employees from ib_employee table where SALARY is a parameter for filter. CREATE PROCEDURE get_employee_details @salary nvarchar(30)ASBEGIN SELECT * FROM ib_employee WHERE salary = @salary;END;

Discussion

No Comment Found

Related InterviewSolutions

Write PL/SQL program to find the sum of digits of a number.
Write PL/SQL program to convert each digit of a given number into its corresponding word format.
Write a PL/SQL code to find whether a given string is palindrome or not.
Write PL/SQL code block to increment the employee’s salary by 1000 whose employee_id is 102 from the given table below.
Write a PL/SQL code to count the number of Sundays between the two inputted dates.
Write a PL/SQL procedure for selecting some records from the database using some parameters as filters.
Write a PL/SQL program using WHILE loop for calculating the average of the numbers entered by user. Stop the entry of numbers whenever the user enters the number 0.