Re: Convert Long to Char in View?

In article <3orpe9$4la_at_piper.Pwc-Tpc.ca>, Ken Werk (werk_at_piper.pwc-tpc.ca) writes:
>Is it possible to create a view which has a column which is the first
>100 characters of a column of type long?
>
>Ken

Sorry Ken it can't be done.

There are some restrictions imposed on the use of LONG and LONG RAW data_types.

You can only have 1 LONG data_type column in any given table.

LONG data_types cannot be used for integrity contraints,

They cannot be used in CONNECT BY, WHERE, GROUP BY, ORDER BY etc statements.

They canot be used i a sleect statement for CREATE TABLE .... AS SELECT .... And they cannot be used in functions like SUSBSTR() INSTR().

The data_type has many features and benfits when used in it's place, but sometimes it's a regular pain the ar... ahem.. neck.

Regards,
Alex Long

--
                          ,     \    /      ,
                         / \    )\__/(     / \   
                        /   \  (_\  /_)   /   \                
 ______________________/_____\__\_at_  @/___/_____\________________ 
|paladin.along.dialix.oz.au 					|
|Alex Long 		   					|		
|Adelaide, South Australia 					|
|_______________________________________________________________|
|Weep not for little Leonie,                   			|
|Abducted by a French Marquis!               			|
|Though loss of honour was a wrench,           			|
|Just think how it's improved her French.         Harry Graham. |
+_______________________________________________________________+
                   |    /\ /      \\       \ /\    |             
                   |  /   V        ))       V   \  |
                   |/     `       //        '     \|
                   `              V                '
                   
_