Stored Procedure Question:

Explain about the case statement present in Stored procedure?

Stored Procedure Interview Question
Stored Procedure Interview Question

Answer:

CASE statement contains a complex conditional construct. If a certain statement is evaluated as true then the search_condition makes sure that the following statement gets executed. If there are no true statements are present then the ELSE clause is executed. An error is generated if there is no statement.


Previous QuestionNext Question
How do you notify DBPAK about Stored Procedure?What is a stored procedure?