User Profile

Collapse

Profile Sidebar

Collapse
Curtiosity
Curtiosity
Last Activity: Apr 7 '06, 06:58 PM
Joined: Apr 7 '06
Location: Utah
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • 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....
    See more | Go to post

    Leave a comment:


  • Curtiosity
    started a topic ORA-00904 error with create or replace view

    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"...
    See more | Go to post
No activity results to display
Show More
Working...