Question
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
More SQL Questions
- What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?
- Which type of trigger fires once for each row affected by the triggering DML statement?
- In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
- Orders(OrderID, CustomerID, Amount) has multiple orders per customer. Which query returns customers whose total order amount exceeds 100000?
- Which SQL constraint ensures that a column’s values are unique across the table?
- Which SQL clause is used to filter results after a GROUP BY operation?
- Which SQL function returns the number of rows in a table?
- Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
- A view is defined as: CREATE VIEW V AS SELECT dept_id, AVG(salary) AS avg_sal FROM Employees GROUP BY dept_id; Can this view be used directly in an UPDATE ...
- Which SQL keyword is used to remove duplicate records from a query result?
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)