Home » SQL & PL/SQL » SQL & PL/SQL » Oracle insert statement (Oracle 12 )
Oracle insert statement [message #676984] Sat, 03 August 2019 18:44 Go to next message
Messages: 1
Registered: August 2019
Junior Member
When the select statement is executed we are getting 'n' number of rows,
but when try to insert the output of the same select statement to the table in the another schema that present in different DB for which synonym is created.
We are getting the message '0' rows inserted.
Before performing the insert statement have executed the alter session statement 'global_names=true'
Re: Oracle insert statement [message #676985 is a reply to message #676984] Sat, 03 August 2019 19:19 Go to previous messageGo to next message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

When you observe different result, you should immediately conclude that something is different.

We can't say what is wrong since you decide to NOT show us using COPY & PASTE exactly what you did & how Oracle responded.
Re: Oracle insert statement [message #676991 is a reply to message #676985] Mon, 05 August 2019 07:35 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
it is really hard to help without the offending code and table structures
Previous Topic: Stored Procedures compile in 11G but do not in 12C (
Next Topic: read and validate file
Goto Forum:

Current Time: Wed Mar 22 08:42:03 CDT 2023