Parameter and keyword description - records, PL-SQL Programming

Parameter and Keyword Description:


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


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.


The datatype is a type specifier. 


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


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
Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th

UNNEST operator in SQL The inverse operator of GROUP is UNGROUP. SQL has an operator, UNNEST, that can be used for similar purposes, but its method of invocation is somewhat p

Ensuring Backward Compatibility   The PL/SQL Version 2 permits some abnormal behavior which Version 8 disallows. Particularly, Version 2 permits you to (i) Make the forw

query to Find the account numbers of all customers whose balance is more than 10,000 $

Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv

Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 JOIN CONTRACT ON EMPLOYEE

Advantages of Invoker Rights The Invoker-rights routines centralize the data retrieval. They are particularly helpful in applications which store data in various schemas. In su

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

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