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
Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP

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

Task 2 [12 marks] Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

Error Handling The PL/SQL makes it easy to detect and process the predefined and user-defined error conditions known as exceptions. Whenever an error occurs, an exception is ra

Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

%NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,