Home » SQL & PL/SQL » SQL & PL/SQL » Convert long-col to varchar2-col and make a view
Convert long-col to varchar2-col and make a view [message #21143] Tue, 16 July 2002 00:39 Go to next message
Samuel Linjer
Messages: 5
Registered: July 2002
Junior Member
Hi,

Is there a way to make a view of a table containing a long column. In the view i want the same column to be varchar2.

eg:
CREATE OR REPLACE VIEW
v_test ( my_column_in_varchar2)
AS SELECT
long_column
FROM
my_table;

It's ok for me that data will be truncated as varchar2 is limited to 32767.

Any ideas ?
Thanks !
//Sam
Re: Convert long-col to varchar2-col and make a view [message #21145 is a reply to message #21143] Tue, 16 July 2002 02:22 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi..
you can't create view like this.. A view is just a shadow of the table. view shows the columns of table only.
Previous Topic: Applications accessibility
Next Topic: Checking the tablespace
Goto Forum:
  


Current Time: Thu Mar 28 10:09:01 CDT 2024