Home » SQL & PL/SQL » SQL & PL/SQL » how to modify the view (oracle10g,linux)
how to modify the view [message #305674] Tue, 11 March 2008 09:13 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
hi,
I have created view based on the stored function..

scripts:

create or replace view sample
as
select get_employees(employee) as employee_id
from employees;
/
desc sample:

employee_id varchar2(4000);

Now i want to reduce the size of the employee_id column in view

how can i resolve this issues
Re: how to modify the view [message #305678 is a reply to message #305674] Tue, 11 March 2008 09:23 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CAST
cast(column as varchar2(XXX))

Regards
Michel
Previous Topic: SQL QUERY - please (merged)
Next Topic: Autonomous Transaction Error 00164
Goto Forum:
  


Current Time: Thu Dec 08 08:20:51 CST 2016

Total time taken to generate the page: 0.11063 seconds