Tagged Questions
1
vote
1answer
49 views
Update field1.table1 based on compound join between table1 and table2 - Oracle
I want to run update statement on Oracle 11g, but it fails with the following error:
SQL Error: ORA-01427: single-row subquery returns more than one row
01427. 00000 - "single-row subquery ...
1
vote
1answer
150 views
DML operation against synonym oracle
I have been reading the GoldenGate 11g R2 installation guide and it states:
Non-supported objects and operations in Oracle DML:
[...]
Synonyms
[...]
But I see in the next section that ...
3
votes
1answer
3k views
Is commit necessary after DML operation in Function/Procedure?
I wonder to know if it is necessary to write commit after insert/delete/update in function/procedure?
Example:
create or replace function test_fun
return number is
begin
delete from a;
return ...
