Database ProgrammingTU Board 2024
Differentiate between stored procedure and stored function with example. How parameterized stored procedure can be used? Explain with example.
10A worked answer is on its wayMeanwhile, read the Database Programming notes for this topic.
Discussion
Loading…
More Database Programming questions
Define database programming. Describe the differences between procedural and non procedural access to a database. [1+4]TU Board 20255What is a subquery? Explain the use of GROUP BY and HAVING clauses in SQL. [1+4]TU Board 20255Explain the concept of parameter modes (IN, OUT, IN OUT) in PL/SQL with examples. [5]TU Board 20255Define trigger. Write the syntax to create a row level trigger in PL/SQL. [1+4]TU Board 20255Write a PL/SQL block using an explicit cursor to display all employee names from the Employee table. [5]TU Board 20255What are constants in PL/SQL? Give syntax and an example. [5]TU Board 20255