give short definition for procedures in pl sql
Question
give short definition for procedures in pl sql
Solution
Procedures in PL/SQL are subprograms that perform a specific action. They are named PL/SQL blocks that are stored in the database and can be invoked repeatedly. The main purpose of a procedure is to hide direct SQL statements from the user and also to extend the capabilities of SQL by incorporating procedural language constructs like conditional statements and loops.
Similar Questions
How can a stored procedure be called from PL/SQL?
What is PL/SQL? Explain the block structure of PL/SQL
The PL/SQL executable section contains which type of statements ?
Which of the following is NOT a component of a PL/SQL package?VariablesCursorsTablesExceptions
Create procedure dept_count proc(in dept name varchar(20),out d count integer)beginselect count(*) into d countfrom instructorwhere instructor.dept name= dept count proc.dept nameendWhich of the following is used to call the procedure given above ?
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.