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
Explicitly specifying the join condition - SQL SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON ON ( IS_CALLED.StudentId = IS_ENROLLED_ON.StudentId ) Now, the key word JO

THEO R Y OF ETERNITY OF LIFE (PRAYER - 1880) - The theory of eternity of life, also called the steady-state theory , states that life has ever been in existence as at presen

CURRVAL and NEXTVAL The series is a schema object which generates the sequential numbers. Whenever you form a sequence, you can specify its primary value and an increment. T

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Keyword and Parameter Description select_statement: This is a query which returns a result set of the rows. Its syntax is such that of select_ into_statement without the IN

Overloading The PL/SQL overloads the subprogram names. That is, you can use similar name for few different subprograms as long as their formal parameters differ in the number

THEO R Y OF CATASTROPHISM OR CATALYSM (CUVIER 1769-1832) - The world has passed thorugh several stages and at the end of each stage there was a catastrophe killing all the

Updating Tables in SQL The topic of updating by describing the assignment operator, ":=" in Tutorial D. SQL uses a different syntax for assignment, using the key word SET and