PLSQL
Oracle Packages List
1765 Oracle provides inbuilt packages that can be used by developer/Programmer working on oracle Databases to generatePLSQL programs for various procudures. These packages are used in developing various application and performs the task that refrains from generating lenght code. Each of these inbuilt Oracle packages comprises of various procedures and fuctions ...
Basic Cursor Writing In PLSQL Procedures
A cursor is a memory area allocated to work with select statements and is declared by a name.Need For CursorIn any PLSQL Statement which is IMPLICIT you may or maynot use a cursor but if the Statement is Explicit the use of cursor in a plsql programs becomes mandatoryBasic operations ...
What Is a Database Trigger in Oracle
Database triggers is a consist os sql and plsq statement which is executed on an predefined event.Database triggers are stored as a database object in oracle.Database triggers is an oracle objects which consist set of statement that is executed on a purticular event.The Statement is a PLSQL block or a ...
IN OUT Parameter In Plsql Procedures
There can be any number of parameters in PLSQL programming environment Each parameters has a mode and a type. The possible modes are IN (read-only), OUT (write-only), and INOUT (read and write). There can be any number of parameters in PLSQL programming environment, Each parameters has a mode and a type. The ...
Mutating Error In Database Trigger
Mutating error is one of the common error which one encounters while working with triggers which can involve operation of a particular table. Mutating error in database triggers is the error encountered by oracle while working or implicitly executing a database trigger. Mutating error, generally this error occurs when a row-level ...