Long and long raw in pl/sql, PL-SQL Programming

LONG and LONG RAW

You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length of a LONG value is 32760 bytes.

You use the LONG RAW datatype to store the binary data or byte strings. The LONG RAW data is like a LONG data, except that the LONG RAW data is not interpreted by the PL/SQL. The highest length of a LONG RAW value is 32760 bytes.

You can insert any LONG value into a LONG database column as the maximum width of a LONG column is 2147483647 bytes. Though, you cannot retrieve a value bigger than 32760 bytes from a LONG column into a LONG variable.

RAW

You use the RAW datatype to store the byte strings or binary data. For example, a RAW variable might store a sequence of graphics characters or a digitized picture. The Raw data is like the VARCHAR2 data, except that PL/SQL does not interpret the raw data.

The RAW datatype takes a required parameter that lets you specify a highest length of up to 32767 bytes. The syntax is as shown below:

RAW(maximum_length)

You cannot use a variable or constant to specify the maximum length; you should use an integer literal in the range 1 to 32767.

Posted Date: 10/2/2012 2:32:31 AM | Location : United States







Related Discussions:- Long and long raw in pl/sql, Assignment Help, Ask Question on Long and long raw in pl/sql, Get Answer, Expert's Help, Long and long raw in pl/sql Discussions

Write discussion on Long and long raw in pl/sql
Your posts are moderated
Related Questions
Application to Export Excel Data to MSSQL Server table I am having a table available in excel format and features the subsequent: - Some text is in Arabic (e.g. UTF-8 encodin

THEO R Y OF SPECIAL CREATION - Life originated on the earth due to natural events by the super natural power. The biblical story of creation of world within six days was p

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

Organi c Evolution Evolution is a slow continuous, irreversible and natural process of change to give rise to advance and diverse forms of life i.e. formation of new specie

SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators.  1. Comparison Opera

Declaring Exceptions The Exceptions can be declared only in the declarative part of the PL/SQL subprogram, block, or package. By introducing its name, you can declare an excep

Using %ROWTYPE The %ROWTYPE attribute gives a record type which represents a row in a table (or view). The record can store the whole row of data selected from the table or fetc

Effects of NULL The numeric variable X, perhaps of type INTEGER, might be assigned NULL. In that case the result of evaluating X + 1 is NULL, and so SET Y = X + 1 assigns NULL

1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

Recursion versus Iteration Dissimilar the iteration, recursion is not crucial to PL/SQL programming. Any problem which can be solved using recursion can be solving using the it