priya

Whenever an Error occurs Exception arises. Error is a bug whereas exception is a warning or error condition. In PL/SQL, an exception and an error are related concepts but have distinct meanings: Error: An error generally refers to any unexpected or undesirable event that occurs during the execution of a program. Errors can be of … Read more

A function returns a value while a stored procedure doesn?t return a value. One key difference between a function and a stored procedure in PL/SQL is the return type. In PL/SQL, a function must return a value, while a stored procedure does not have a return type. Functions are designed to return a single value, … Read more

No. PL/SQL doesn’t support the data definition commands like CREATE. Yes, PL/SQL (Procedural Language/Structured Query Language) supports the CREATE command, but with a specific context. In PL/SQL, you use the CREATE command to create stored procedures, functions, triggers, packages, types, and other database objects. For example, you can use the CREATE PROCEDURE statement to define … Read more

Greeting := ‘Hello’ || ‘World’; In PL/SQL, you can concatenate two strings using the || operator. To achieve the desired result of concatenating the words “Hello” and “World” and assigning it to a variable named Greeting, you can use the following single statement: Greeting := ‘Hello’ || ‘World’; This statement uses the || operator to … Read more

Exception is an error handling part of PL/SQL. There are two type of exceptions: pre_defined exception and user_defined exception. In PL/SQL, an exception is an error or an unexpected event that occurs during the execution of a program. When such an error occurs, the normal flow of the program is disrupted, and an exception is … Read more