Parameter and keyword description - records, PL-SQL Programming

Parameter and Keyword Description:

record_type_name:

This identifies the user-defined type specifier that is used in the subsequent declarations of the records.

NOT NULL:

This constraint prevents the assigning of the nulls to the field. At the run time, trying to assign the null to a field, defined as NOT NULL raises the predefined exception VALUE_ ERROR. The constraint NOT NULL should be followed by an initialization clause.

datatype:

The datatype is a type specifier. 

:= | DEFAULT:

This keyword or operator allows you to initialize the fields to the default values.

expression:

This is a indiscriminately complex combination of the constants, variables, literals, operators, & function calls. The easiest expression consists of a single variable. When the declaration is explained, the value of the expression is assigned to the field. The value and the field should have the compatible datatypes.

Posted Date: 10/8/2012 7:35:48 AM | Location : United States







Related Discussions:- Parameter and keyword description - records, Assignment Help, Ask Question on Parameter and keyword description - records, Get Answer, Expert's Help, Parameter and keyword description - records Discussions

Write discussion on Parameter and keyword description - records
Your posts are moderated
Related Questions
IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Project Description: I am looking to change FullCalendar to add/delete sql server data when events are removed or dropped from Calendar. Events should only be included by dra

Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

Collections:   The collection is an ordered group of elements, all of similar type (for illustration, the grades for a class of students). Each element has an exclusive subsc

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

FORALL Statement The FORALL statements instruct the PL/SQL engine to bulk-bind the input collections before sending them to the SQL engine. Though the FORALL statement consists

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

Closing a Cursor Variable The CLOSE statement disables the cursor variable. After that, the related result set is undefined. The syntax for the same is as shown below: CLOS

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T