SQL - Oracle long datatype

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 152 of 171

Oracle long datatype

I'm using oracle9i to create a table which stores lyrics in long datatype. But if i store a long string of text and display it from the table, it displays only 80 chars. So someone help me how to store the whole lyrics txt file

Total Answers and Comments: 3

Last Update: June 24, 2008 Asked by: gReaen

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 29, 2008 08:10:13

patilpravin_1981

Member Since: December 2007 Contribution: 29

RE: Oracle long datatype

I think alter the table structure give antoher data type data typa -bLOB

Is this answer useful? Yes | No

May 16, 2008 04:30:01

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: Oracle long datatype

If text is not visible use
SET LONG 2000.

Is this answer useful? Yes | No

June 24, 2008 05:26:36

ramyaselvi16

Member Since: June 2008 Contribution: 15

RE: Oracle long datatype

Variable length character values up to 2 gigabytes. Only one LONG column is allowed per table. You cannot use LONG datatype in functions WHERE clause of SELECT in indexing and subqueries.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank