Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
typethis attribute gives the datatype of a formerly declared collection cursor variable object field record database column or variabledatatypethis
rowtypethis attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor the fields in
keyword and parameter descriptionselectstatementthis is a query which returns a result set of the rows its syntax is such that of select
product-specific packagesthe oracle and different oracle tools are supplied with the product-specific packages which help you to build the
package standardthe package named standard defines the plsql atmosphere the package specification globally declares the exceptions types and
the package bodythe package specification is implemented by the package body that is the package body has the definition of every cursor and the
begin parameter description in pl sqlbeginthis keyword signals the beginning of the executable section of a plsql block that contains executable
declarethis keyword signals the beginning of the declarative section of the plsql block that contains local declarations the items declared locally