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
Structure of an Object Type: Similar to package, an object type has 2 parts: the specification and the body. The specification is the interface to your applications; it declar

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

THEO R Y OF SPECIAL CREATION - Life originated on the earth due to natural events by the super natural power. The biblical story of creation of world within six days was p

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n

Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

GOTO Statement   The GOTO statement branches categorically to a block label or statement label. The label should be exclusive within its scope and should precede a PL/SQL bloc

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

Updating Objects: To change the attributes of objects in an object table, you can use the UPDATE statement, as the illustration below shows: BEGIN UPDATE persons p SET p

Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con