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…………)
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
You've reached the end of your free preview.
Want to read all 5 pages?
- Fall '19
- Return statement, Control flow