Data types in sql - character, PL-SQL Programming

Data Types in SQL - Character

CHARACTER or, synonymously, CHAR, for character strings. When this type is to be the declared type of something (e.g., a column), the permissible values are further constrained by a maximum length specification given in parentheses and optionally by the key word VARYING, indicating that values shorter than the maximum, including the empty string '' , are also permissible. Examples: CHAR(5) for strings of five characters only, CHARACTER VARYING (100), which can be abbreviated to VARCHAR(100), for strings of up to one hundred characters. The last two are alternative spellings for the same declared type.

The type CHARACTER LARGE OBJECT, or CLOB, allows for inclusion of strings that are longer than the longest supported by the other CHARACTER types. Note that in the terminology of the theory book CHARACTER is a kind of type generator. The key word does not of itself denote a type, but only does so when qualified by a length specification. A similar remark applies to some of the other type names used in SQL.

Posted Date: 1/18/2013 1:55:48 AM | Location : United States







Related Discussions:- Data types in sql - character, Assignment Help, Ask Question on Data types in sql - character, Get Answer, Expert's Help, Data types in sql - character Discussions

Write discussion on Data types in sql - character
Your posts are moderated
Related Questions
Conditionals - SQL At first sight SQL does not appear to have a single operator for expressing logical implication. In this respect it would be in common with most programming

Effects of NULL in Table Literal When a VALUES expression appears as the source value for an SQL INSERT statement, the key word NULL can appear as a field value, such that for

Varrays versus Nested Tables The Nested tables are differing from varrays in the following ways: 1)  Varrays have a maximum size, while nested tables do not. 2)  Varrays are

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

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

Use of Table Expressions - Expressing Constraint Conditions With the exception of key constraints, the examples in the theory book all explicitly reference at least one relvar

Managing Cursors The PL/SQL uses 2 types of cursors: implicit and explicit. The PL/SQL declares a cursor implicitly for all the SQL data manipulation statements, including th

Effects of NULL for Multiple Assignments - SQL If the row expression given as the source for a multiple assignment evaluates to NULL, then NULL is assigned to each target. If