Re: Oracle Data types

In article <4ebg6n$t8s_at_news.missouri.edu>, kodali_at_cclabs.missouri.edu (Ravi Kodali) writes:
|>I created a table with several columns and one of them is a LONG RAW
|>datatype and when I try to modify another column from VARCHAR2 to LONG
|>using ALTER TABLE ... MODIFY(... LONG); it keeps giving me the following
|>error and doesn't allow me to modify it.
|>
|>ERROR at line 1:
|>ORA-01754: a table may contain only one column of type LONG
|>
|>so does it mean that I can't have more than one column with the
|>type anything which starts with LONG.
|>
|>please throw some light.

Yes, that is what the manual says. LONG RAW is equivalent to LONG.

-- 
With best regards,
	Harri
-----------------------------------------------------------------------
(Opinions stated above are mine, not Oracle Corporation's)
Oracle Corporation
Harri Kaukovuo,  Applications Engineer		Tel.	+1-415-506 3258
500 Oracle Parkway, P.O.Box 659304		Fax	+1-415-506 7292
REDWOOD SHORES, CA 94065, USA			hkaukovu_at_us.oracle.com