ORA-00923: FROM keyword not found where expected

This is a discussion on ORA-00923: FROM keyword not found where expected within the Oracle Database forums, part of the Database category; Hi Guys I had a problem I am trying to create a materialized view wjth a select statement which contains ...

		Exforsys > Database > Oracle Database
ORA-00923: FROM keyword not found where expected

LinkBack

Thread Tools

#1 (permalink)

03-02-2006, 05:01 AM

rite2sekhar rite2sekhar is offline

Junior Member

Join Date: Sep 2004

Posts: 13

ORA-00923: FROM keyword not found where expected

Hi Guys

I had a problem

I am trying to create a materialized view wjth a select statement which contains 200 columns I am getting error
ORA-00923: FROM keyword not found where expected

but when i remeoved any of one column column it is creating but if i add one more column I am getting above error

obsulutely there is no syntax error

can any one help me ---Very urgent please

thanks in advance

« Create a class with wrapper methods for DBMS_APPLICATION_INFO | Multiple Oracle Instances »

Thread Tools
Show Printable Version Email this Page

Posting Rules
You may not post new questions You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT -4. The time now is 11:50 PM.