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
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
I have created view based on the stored function..


create or replace view sample
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: 65138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
cast(column as varchar2(XXX))

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

Current Time: Thu Aug 17 22:21:30 CDT 2017

Total time taken to generate the page: 0.21536 seconds