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
Table Literals - SQL One might expect SQL to support table literals in the manner illustrated in Example 2.2, but in fact that is not a legal SQL expression. Example: Not a

Interesting properties of CROSS JOIN - SQL Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOI

Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke

Overloading The PL/SQL overloads the subprogram names. That is, you can use similar name for few different subprograms as long as their formal parameters differ in the number

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

Find the account numbers of all customers whose balance is more than 10,000 $

Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam

Short-Circuit Evaluation When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops computing the expression as soon as the result

Effects of NULL for Table Expression Here's an important distinction between expressions denoting tables and expressions denoting multisets of rows: a table expression cannot

Bulk Binds advantages In the Embedded Oracle RDBMS, the PL/SQL engines accept any valid PL/SQL subprogram or block. As the figure shows, the PL/SQL engine executes all procedur