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
Example of Check Constraints Example: Workaround for when subqueries not permitted in CHECK constraints CREATE FUNCTION NO_MORE_THAN_20000_ENROLMENTS ( ) RETURNS BOOLEAN

Deriving Predicates from Predicates in SQL The corresponding section in the theory book describes how predicates can be derived from predicates using (a) the logical connectiv

Seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of client(s) information (i.e. Name, Account Number, Address etc.) int

Brewbean's is implementing a new discount for return shoppers - every fifth completed order receives a 10% discount. The count of orders for a shopper is placed in a packaged varia

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

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

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s

Avoid the NOT NULL Constraint In the PL/SQL, using the NOT NULL constraint incur a performance cost. Consider the illustration as shown below: PROCEDURE calc_m IS m NUMB

Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th

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