473,472 Members | 2,153 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to convert from long to varchar2?

61 New Member
I have a column in a table with long datatype
and I want to convert all values in this column to varchar2 'no problem if the data been truncated on 4000 characters of length'.

may someone help me??

best regards..
osman
Mar 10 '11 #1
2 5522
debasisdas
8,127 Recognized Expert Expert
Better to use CLOB instead of using varchar data type.
Mar 10 '11 #2
amitpatel66
2,367 Recognized Expert Top Contributor
if that is custom table then not to use LONG data type and convert that to CLOB.

Check Ask Tom
Mar 20 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Fred | last post by:
Hi all, I have a nice problem. I´m trying to convert a Long to varchar2. It works when the long field doesn´t contain more than 2000 characters. How do I solve this? I´m working with Oracle 7...
3
by: seema | last post by:
I am working under a Linux environment, and I want to convert a long int into a string. It looks doesnt't have a function such ltoa,itoa on stdlib. How Can I do that? I tried to work with double...
3
by: Mullin Yu | last post by:
I need to pass a long value from C# to a sql stored procedure, but got error: "SqlParameterCollection accepts non-null sqlParameter type objects, not Int64) Following is my c# coding long...
3
by: Chua Wen Ching | last post by:
I have a problem. But on .NET 1.1 My Scenario: Actually I will have a string of hexadecimals read from a xml file. Then from the hexadecimals, i will add 1 value whenever i made any...
4
by: Jan | last post by:
How can I convert Long value to array of bytes?
7
by: wenmang | last post by:
what is format for sprintf to convert long long integer (64 bits) to string?
1
by: reorex | last post by:
Hello All, Help needed. I'm doing a search engine program using Visual basic 6.0 and connecting to Oracle 7 version. The problem is when I created an SQL statement, i have encountered this error...
1
by: Taka | last post by:
Hi there... The application im writing needs to calculate a persons age(as long) by entering the day, month and year into seperate textboxes. I want the application to calculate the age by using...
2
by: mzladyd | last post by:
The source table has tbldate formated as long and I want it to be date. I've created another table and set the correct format and have tried to convert to date or char, but I continue to get error...
2
by: Jcan | last post by:
hi I have a long variable: long id = 0x0457; which in decimal is 1111 I need to convert id into a char array with its ascii values.
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.