Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while creating view - version Oracle 11g

S567Jul 23 2019 — edited Jul 24 2019

Hi Experts,

i am trying to create a view by selecting few feilds from table

I am getting an error saying invalidĀ  this table has feild name called "where"

.Error is ": invalid user.table.column, table.column, or column specification"

"

create or replace view test_data

as

select

,m.how

,m.who

,m.what

,m.where

,m.why

,m.top_products

,m.order_number from master_table.

Can you please suggest

This post has been answered by jaramill on Jul 23 2019
Jump to Answer
Comments
Post Details
Added on Jul 23 2019
22 comments
863 views