I believe the following will do what you want.
WITH poupd AS
(SELECT LINE_STATUS,
LINE_TYPE,
PROMISE_DATE,
LEAD_TIME,
ITEM_NUMBER,
ORDER_UOM_CODE,
ORDER_QTY
FROM ppo_master_detail ponum,
supplierdetail sd
WHERE ponum.subscriber_id = 65
Hi
2016-01-20 11:45 GMT+01:00 Sachin Srivastava :
> Boss !!
>
> I am using postgres 9.4, so how to handle this.
>
>
I don't know Ora2Pg - try to find some option to generate in old format -
or manually rewrite to supported syntax
UPDATE tab SET a = x.a, ... FROM x
Regards
Pavel
Boss !!
I am using postgres 9.4, so how to handle this.
On Wed, Jan 20, 2016 at 4:11 PM, Pavel Stehule
wrote:
> Hi
>
> 2016-01-20 11:36 GMT+01:00 Sachin Srivastava :
>
>> Dear Folks,
>>
>> How to handle the below error, please suggest. I have migrated my
>> database from oracle to postgres thro
Hi
2016-01-20 11:36 GMT+01:00 Sachin Srivastava :
> Dear Folks,
>
> How to handle the below error, please suggest. I have migrated my database
> from oracle to postgres through Ora2PG then I am getting this error for
> function.
>
> If I am writing the code for every column which are within set (
Dear Folks,
How to handle the below error, please suggest. I have migrated my database
from oracle to postgres through Ora2PG then I am getting this error for
function.
If I am writing the code for every column which are within set (column
name1, column name2, etc) then it's running successfully
