[email protected] - Practical-2 Aim:Implementation of PLSQL...

This preview shows page 1 - 5 out of 5 pages.

Practical-2 Aim:Implementation of PLSQL for Trigger,Function,Curser,Procedure. 1 Function This is the subprogram that will returns single value on execution.This is used to execute the value.the function decleration,definition and function call must be there to execute the function. Syntax Create function function_name(parameters1,parameter2…….) 2 Procedures As function returns a value ,a procedure will not return any value it is used to perform a certain action.This is the only difference in procedures and functions. Syntax Create procedure procedure_name(parameters1…………)
Image of page 1
3 Cursers When an SQL statement is processed, Oracle creates a memory area known as context area. A cursor is a pointer to this context area. It contains all information needed for processing the statement. In PL/SQL, the context area is controlled by Cursor. A cursor contains information on a select statement and the rows of data
Image of page 2
Image of page 3
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 5 pages?

  • Fall '19
  • Return statement, Control flow

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture