Technical Interview Questions
There are two way to execute a stored procedure. From the SQL prompt, write EXECUTE or EXEC followed by procedure_name. EXECUTE or [EXEC] procedure_name; Simply use the procedure name procedure_name; In PL/SQL, you can execute a stored procedure using the EXECUTE statement or its shorthand notation EXEC. Here is the syntax: EXECUTE procedure_name(parameters); or EXEC … Read more
The DROP PACKAGE command is used to delete a package. In PL/SQL, the correct command to delete a package is: DROP PACKAGE package_name; Replace package_name with the actual name of the package you want to delete. The DROP PACKAGE statement is used to remove a PL/SQL package from the database.
PL/SQL packages have the following two parts: Specification part: It specifies the part where the interface to the application is defined. Body part: This part specifies where the implementation of the specification is defined. In PL/SQL, a package consists of two parts: Specification: This is the interface to the package. It declares the types, variables, … Read more
A PL/SQL package can be specified as a file that groups functions, cursors, stored procedures, and variables in one place. In PL/SQL, a package is a database object that groups related functions, procedures, variables, and other constructs together as a single, named unit. It is a way to organize and modularize code in the Oracle … Read more
It returns the Boolean value TRUE if no rows were processed. In PL/SQL, the cursor attribute SQL%NOTFOUND is a boolean attribute that evaluates to TRUE if a cursor fetch returns no rows. It is commonly used to check whether a cursor has reached the end of the result set. Here’s a brief explanation: If SQL%NOTFOUND … Read more