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
IS NULL Operator The IS NULL operator returns the Boolean value TRUE whenever its operand is null or FALSE if it is not null. The comparisons including the nulls always yield NU

Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

EXECUTE IMMEDIATE Statement   The EXECUTE IMMEDIATE statement prepare (parses) and instantly executes a dynamic SQL statement or an anonymous PL/SQL block. Syntax:

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

What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em

SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.parent_fname), b.parent_lname,b.parent_tphone FROM child a,parent b WHERE a.parent_id=b.parent_id ORDER BY a.child_fnam

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

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an