Data types and representations, PL-SQL Programming

Data Types and Representations

This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to define types.

Example: A Type Definition

TYPE SID POSSREP SID {C CHAR

CONSTRAINT LENGTH(C) <= 5

AND

STARTS_WITH(C, 'S')

AND

IS_DIGITS (SUBSTRING(C, 1)))

} ;

 

Posted Date: 1/18/2013 2:17:11 AM | Location : United States







Related Discussions:- Data types and representations, Assignment Help, Ask Question on Data types and representations, Get Answer, Expert's Help, Data types and representations Discussions

Write discussion on Data types and representations
Your posts are moderated
Related Questions
%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

Blocks: The fundamental program unit in the PL/SQL is the block. The PL/SQL block is defined by the keywords BEGIN, DECLARE, EXCEPTION, and END. These keywords partition the b

%NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state

Need Azure CRM Web Application with two-factor authentication We presently have a CRM-like database stored on MS Azure that we presently access over an MS Access application. It

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

Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta

Information Hiding   With the information hiding, you see only the details that are significant at a given level of algorithm and data structure design. The Information hiding

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

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns