Chris Velevitch wrote:
What is the point of the create or replace view command if you can't change the column and data types ?
You could have a calculated column and change the calcuation. You could change the sort order, selection, or grouping clauses. Just to name two.