jagomart
digital resources
picture1_18plsqladv


picture2_18plsqladv picture3_18plsqladv

 71x       Filetype PDF       File size 0.72 MB       Source: web.cs.laurentian.ca


File: 18plsqladv
Procedures, Functions and Triggers Slides • Anonymous PL/SQL programs: un-named database objects, submitted to PL/SQL interpreter and run but not available to other users or called by other procedures. &bull ...

icon picture PDF Filetype PDF | Posted on 07 Feb 2023 | 2 years ago
Partial capture of text on file.

						
									
										
									
																
													
					
The words contained in this file might help you see if this file matches what you are looking for:

...Procedures functions and triggers slides anonymous pl sql programs un named database objects submitted to interpreter run but not available other users or called by that can be referenced used stored groups of statements allow you move code enforces business rules from your application the performance gains due two reasons processing complex may performed with therefore server since procedural is within fairly static benefit reuse same queries program units side are in as execute on advantages a central location accessible all always whenever connection made disadvantages forces done if very busy response time will slow client file system workstation unit description where executed type procedure accept multiple operating input parameters returns output values function single value library contains for related package variables trigger executes when specific action occurs such inserting updating deleting records name parameter mode datatype parametern how changed passed read only canno...
Haven't found the file you're looking for? You can try sending a request file
Comment

no comments yet
Please Login to post a comment.

no reviews yet
Please Login to review.