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
Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

ROWID and UROWID Internally, every database table has a ROWID pseudo column that stores binary values known as rowids. Each rowid shows the storage address of a row. A physical

Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

Initializing and Referencing Collections Until you initialize a collection, a nested table or varray is automatically null (i.e. the collection itself is null, not its elements)

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illu

Question: (a) The objective of query optimization is to choose the most efficient strategy for implementing a given relational query, thereby improving the system performance. On

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a

ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quantity BEGIN INSERT INTO bb_basketitem VALUES (88,8,10.8,21,16,2,3); END; Brewbean’s wants to add a check