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
Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

write the program for traffic control system with 10 second, 15 secod, and 20 second delay

Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl

Count Operator in SQL Example: Counting the students who have scored more than 50 in some exam (SELECT COUNT (*) FROM (SELECT DISTINCT StudentId FROM EXAM_MARK WHE

Data Types and Representations This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to de

to write a heap sort program usin pl-sql

SQL Pseudocolumns The PL/SQL recognizes the following SQL pseudocolumns, that returns the specific data items: LEVEL, NEXTVAL, CURRVAL, ROWID, & ROWNUM. The Pseudocolumns are n

The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

Pl/sql Conditional Control: IF statements Frequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statem

What Are Subprograms? The Subprograms are named PL/SQL blocks which can take parameters and be invoked. The PL/SQL has 2 types of subprograms known as the procedure s and func