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
Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of

Declaring a Cursor The Forward references are not allowed in the PL/SQL. Therefore, you must declare a cursor before referencing it in other statements. Whenever you declare a

Rephrase Conditional Control Statements When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops evaluating the expression as s

Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh

INSERT Command in SQL Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the targ

Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT.  A screen dump of the output is acceptable. Show as many rows as you can. A screen dump i

Redeclaring Predefined Exceptions Keep in mind that, the PL/SQL declares predefined exceptions globally in the package STANDARD; Therefore you need not declare them yourself.