Database ProgrammingTU Board 2023
Define stored procedure. Explain different parameter modes used in stored procedures. Also differentiate between functions and stored procedure with examples.
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