Merge Question

[Gayathri]

Hi All,

I have a scenario similar to "ORA-30926: unable to get a stable set of rows in the source tables" error that we get in the Merge statement.

i.e., 1 row in the Target table result in Multiple rows in the source table.

say if 2 rows are returned by the source table, then i need to update 1 row in the target and insert 1 row to target as well.

Is there a way to do that? Please suggest?

Thanks,

[javor]

It's not quite clear in your request: what is the criteria to select which exactly row to be used for inserting and which for updating. And which row should be the updated one?

[ddf]

You need to post more information:

Oracle version you're using (4 or 5 numbers, like 11.2.0.3.0)

The merge statement you're trying to use

Without that information we can't answer your question.

David Fitzjarrell