Quotes around alias names
I found the answer to my problem from another source, but thought I would post it here in case it could benefit someone else:
"I think the problem is in your use of explicit capitalization in the aliases for the columns of your views. Once you put double quotes around a column alias you must put double quotes around any reference to it and match the capitalization exactly from then on....
User Profile
Collapse
-
ORA-00904 error with create or replace view
I have done a create or replace view called creditcard1. If I do a "select * from creditcard1" it retrieves the data just fine. If I try to do a statement where I am listing the column names it doesn't recognize them.
create or replace view creditcard1 as
select
pidm
,tbraccd_term_c ode as "Term"
,tbraccd_detail _code as "Detail_Cod e"
,tbbdetc_desc as "Detc_Desc"...
No activity results to display
Show More
Leave a comment: