Google News
logo
PL/SQL - Interview Questions
Write a simple procedure to select some records from the database using some parameters.
Example :
CREATE PROCEDURE get_customer_details @age nvarchar(30), @city nvarchar(10)
AS

BEGIN
SELECT * FROM customers WHERE age = @age AND city = @city;
END;
Advertisement