Count Users
Oracle PL/SQL Functions Public
Oracle PL/SQL
Oracle PL/SQL is Oracles extension for SQL and Oracle relational database. Oracle PL/SQL adds support for procedural language features such as control statements, loops and classes. This allows the developer to further optimize and refine queries at the database, rather than application layer.
Functions
The purpose of a function is generally to compute and return a single value. As a crucial building block of modern programming, being able to define and modify functions is crucial for developers of any skill level.
Public
Public questions (free account) are common interview questions. They are great for practicing, or if you want to filter candidates using the classic problems.
Consider the following code:
CREATE OR REPLACE FUNCTION count_users RETURN NUMBER IS user_count NUMBER; BEGIN SELECT COUNT(*) INTO user_count FROM users; RETURN user_count; END; /
Select the statements that are correct.
(multiple correct answers possible)