Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
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
keyword and parameter descriptionlabelnamethis is an undeclared identifier which optionally labels the plsql block when used labelname should be
expressionthis is a randomly complex combination of constants variables literals operators amp function calls the simplest expression consists of a
using pragma restrictreferencesthe function called from the sql statements should obey certain rules meant to control the side effects to check for
using invoker rightsby default the stored procedure executes with the privileges of its definer not its invoker these procedures are bound to the
remote operationsas the illustration shows below the plsql subprograms can execute the dynamic sql statements which refer to the objects on a remote
pass the nulls to a dynamic sqlpassing nullsassume that you want to pass the nulls to a dynamic sql statement for illustration you may write the
using cursor attributesevery cursor has 4 attributes notfound found isopen and rowcountif appended to the cursor name they return the helpful
benefit of the dynamic sqlthis part shows you how to take full benefit of the dynamic sql and how to keep away from some of the common
parameter modesyou do not require to specify a parameter mode for the input bind arguments those used for illustration in the where clause as the
need for dynamic sqlyou need dynamic sql in the situations as follows1 you would like to execute a sql data definition statement like create a data
dynamic sqlthe most plsql programs do a predictable specific job for illustration a stored procedure may accept an employee number and salary
deleting objectsyou can use the delete statement to eradicate objects from an object table to eradicate objects selectively you use the where clause
updating objectsto change the attributes of objects in an object table you can use the update statement as the illustration below showsbeginupdate