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
Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

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

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Brewbean's is implementing a new discount for return shoppers - every fifth completed order receives a 10% discount. The count of orders for a shopper is placed in a packaged varia

Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

Scope Rules You cannot declare an exception twice in the similar block. Though, you can, declare the similar exception in 2 different blocks. The Exceptions declared in a bloc

Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no