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
Using Operator VALUE: As you may expect, the operator VALUE returns the value of an object. The VALUE takes its argument a correlation variable.  For illustration, to return a

Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_

Inserting Objects: You can use the INSERT statement to add objects to an object table. In the illustration below, you insert a Person object into the object table persons:

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

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

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

Forward Declarations The PL/SQL needs that you declare an identifier before using it. And hence, you should declare a subprogram before calling it. For illustration, the decla

Semidifference via EXCEPT and JOIN - SQL SELECT * FROM (SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' EXCEPT DISTINCT CORRESPONDING SELECT StudentId

set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_divide then d