SQL*Plus (MOSC)

MOSC Banner

Query that works in SQL Developer gives error ORA-00998 on column tp.job when I try and create a vie

edited May 22, 2013 8:00PM in SQL*Plus (MOSC) 1 commentAnswered
The following query works when I run it, yet when I try and create a View I get the error ORA-00998. I have tried aliasing the column t.job, with no success. I've read documentation, and still don't understand what I need to do to create this view. Any insights would be most appreciated.
Select T.Job  ,(Select Name From Gl_Companymastr C Where C.Company=(Select Company From Jc_Headermaster H Where H.Job=T.Job))  As Company_Name,T.Ticket_Number,T.Ticket_Date,T.Time,T.Customer,
(Select Name From Ar_Customermast Cm Where Cm.Company=(Select Company From Jc_Headermaster H Where H.Job=T.Job) And Cm.Customer=T.Customer) As Customer_Name,Nvl(T.Customer_Job,' ') Customer_Job,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center