Chapter 17. Calling Functions in SQL
Beginner
Q: | |
17-1. | Generally, the answer is “Yes! You can call your own PL/SQL functions from within a SQL statement.” There are, however, a number of restrictions and requirements governing how and when you can do this. The following exercises test your knowledge of these conditions. |
Q: | |
17-2. | No. When executed inside a SQL statement, your functions can operate only on individual column values within a single row. |
Q: | |
17-3. | First, here is the definition of the function: CREATE OR REPLACE FUNCTION totcomp (sal_in IN PLS_INTEGER, comm_in IN NUMBER := NULL) RETURN NUMBER IS BEGIN RETURN (sal_in + NVL (comm_in, 0)); END; / Now you can apply that function back into the statement: SELECT ename, totcomp (sal, comm) total FROM emp WHERE totcomp (sal, comm) > 1000; |
Q: | |
17-4. | The statements are:
|
Q: | |
17-5. | No, you cannot directly access a procedure ... |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.