Hi all,
I was trying to execute a merge command query in when button pressed trigger. When compiling it is showing an error
" Encountered the symbol "INTO" when expecting one of the following :
:= .(@;<a SQL statement> "
merge into tablename s using tablename on (condition)
when matched then
update set (condition)
when not matched then
insert (condition)
is the syntax that i used.
The version of oracle im using is 10g forms and 10.2.0.1.0 database. 32-bit Windows XP is the OS.
Thanks in advance.