What is a Case Statement in PL/SQL?

1.	What is a Case Statement in PL/SQL?
Answer» The schema objects CREATED with PL/SQL is Packages, Triggers, Cursors, etc. Packages Packages are the schema objects that groups LOGICALLY related PL/SQL types and variables. Triggers Triggers are used to enforce referential integrity, auditing, or EVEN applying security authorizations. It prevents invalid transactions and gather statistics on table access. Cursors Cursors has information about processing the statement. It holds the rows (one or more) RETURNED by a SQL statement.

Answer»

The schema objects CREATED with PL/SQL is Packages, Triggers, Cursors, etc.

Packages

Packages are the schema objects that groups LOGICALLY related PL/SQL types and variables.

Triggers

Triggers are used to enforce referential integrity, auditing, or EVEN applying security authorizations. It prevents invalid transactions and gather statistics on table access.

Cursors

Cursors has information about processing the statement. It holds the rows (one or more) RETURNED by a SQL statement.

Discussion

No Comment Found

Related InterviewSolutions

What are the programming constructs supported by PL/SQL?
Why do we use VSIZE() function in PL/SQL?
How to pad a string with zeros on the right in PL/SQL?
What are the types of Strings in PL/SQL?
Does VARRAY exist in PL/SQL?
What are the guidelines to be used before creating a PL/SQL Package?
What is the use of WHEN clause in PL/SQL?
How to create a user-defined SUBTYPE in PL/SQL?
Can a %ROWCOUNT attribute returns the total number of rows returned by the FETCH command?
Why do we use the TIMESTAMP datatype in PL/SQL?

What is a Case Statement in PL/SQL?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment