Database Administration (MOSC)

MOSC Banner

"missing VALUES keyword"

edited Dec 17, 2013 11:07AM in Database Administration (MOSC) 17 commentsAnswered
Experts,

I read lots of articles, ..but can't resolve this simple statements..:

Insert into F40UI74_Archive where (
select * from F40UI74 a, F4211 b
where a.awdoco=b.sddoco and a.awdcto=b.sddcto
and a.AWKCOO=b.sdkcoo and a.awlnid=b.sdlnid 
and b.sdcndj=0
and b.sdupmj between 113256 and 113263
)

log result:

Error starting at line 1 in command:
Insert into F40UI74_Archive where (select * from F40UI74 a, F4211 b)
where (a.awdoco=b.sddoco and a.awdcto=b.sddcto and a.AWKCOO=b.sdkcoo and a.awlnid=b.sdlnid and b.sdcndj=0 and b.sdupmj between 113256 and 113263)

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