Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
name resolution during the compilation the plsql compiler relates identifiers like the name of a variable with an address or memory location
running the plsql wrapperto run the plsql wrapper go through the wrap command at your operating system prompt by using the syntax as shownwrap
advantages of wrapping the plsql wrapper convert the plsql source code into a transitional form of the object code by hiding the application
parameter and keyword description tablereferencethis keyword identifies the table or view that should be accessible when you execute the update
parameter and keyword descriptioncollectionnamethis keyword identifies the index-by table nested table or varray formerly declared within the present
parameter and keyword descriptionsqlthis sql is the name of the implicit sql cursorfoundthis attribute results true if an insert delete or update
parameter and keyword descriptionselectitemthis selectitem is a value returned by the select statement and then assigned to the equivalent variable
parameter and keyword descriptionrecordtypenamethis identifies the user-defined type specifier that is used in the subsequent declarations of the
parameter and keyword descriptionprocedurenamethe user-defined procedure is declared by this constructparameternamethis identifies the formal
parameter and keyword descriptionpackagenamethis construct identifies the packageauthid clausethis determine whether all the packaged subprograms
parameter and keyword descriptioncursorvariablenamethis identifies a cursor variable or the parameter formerly declared within the present
parameter and keyword descriptiontypenamethis identifies a user-defined type specifier that is used in the subsequent declarations of the
parameter and keyword descriptionlabelnamethis is an undeclared identifier which optionally labels a loop when used the labelname should be enclosed
parameter and keyword description tablereferencethis identifies a table or view which should be available when you execute the insert statement
keyword and parameter descriptionbooleanexpressionthis is an expression which results the boolean value true false amp null it is related with a
keyword and parameter descriptionlabelnamethis is an undeclared identifier which labels an executable statement or the plsql block you can use a goto
parameter amp keyword descriptionfunctionnamethe user-defined function is identifying by that keywordparameternamethis identifies the formal
keyword ampparameter descriptionindexnamethis is an undeclared identifier which can be referenced only within the forall statement and only as the
parameter and keyword descriptioncursornamethis identifies an explicit cursor formerly declared within the present scopecursorvariablenamethese
keyword amp parameter descriptionbooleanexpressionthis is an expression which yields the boolean value that is true false amp
parameter and keyword descriptionexitan unconditional exit statement ie one without a when clause exits the present loop instantly the execution
parameter and keyword descriptiondynamicstringthis is a string variable literal or expression which represents a sql statement or the plsql
keyword amp parameter descriptionwhenthis keyword introduces the exception handler you can have many exceptions execute the similar sequence of the
keyword amp parameter descriptionpragmathese keywords signify that the statement is a pragma ie compiler directive the pragmas are processed at the
keyword and parameter descriptiontablereferencethis specifies a table or view that should be accessible when you execute the delete statement and for