Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paKOW-0003V0-MU for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2023 17:49:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1paKOV-0006P4-9C for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2023 17:49:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paKOU-0006Nn-CL for pgsql-admin@lists.postgresql.org; Thu, 09 Mar 2023 17:49:34 +0000 Received: from resqmta-a1p-077721.sys.comcast.net ([2001:558:fd01:2bb4::a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paKOM-00050w-1z for pgsql-admin@lists.postgresql.org; Thu, 09 Mar 2023 17:49:33 +0000 Received: from resomta-a1p-076786.sys.comcast.net ([96.103.145.235]) by resqmta-a1p-077721.sys.comcast.net with ESMTP id aF45p95XGNV5TaKOFpbWJL; Thu, 09 Mar 2023 17:49:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1678384159; bh=sMbEFXQTkTWn2CGqfEd4jPZsXgyuAGO3EC4J8oTWfkk=; h=Received:Received:Content-Type:From:Mime-Version:Subject:Date: Message-Id:To:Xfinity-Spam-Result; b=BHv60F/biApNj4QtoYpuzv3ZD+N+vPiULsluVMtym4IEriK5yu6tJidvSeKT9E4Dd KGRllRKH6dA0IdiHZE3DUgU3o3VDjZNsehFlTDytUq+FdSd8QewIKwzS70oc5DQ/1X TmKRKuEOFI/KpkTZZGjV+FlqWPSsphtQqRuyohnId6D9/NXpPXZyvHr0urDSXIqicy KmpaqUPIEFsksj7wmNRwh1XLNmQ8fhb9xCU3rukesCIaV4bPKv93AzZ3SFSGI3q7XC Oi2JuiCgUnG1H3brshzHGPbrf8KiATdJdrKX08MFfS2i8LfOn8AeDFzDKzimFrWlaQ PFSKNz6SEHZqA== Received: from smtpclient.apple ([IPv6:2601:240:d000:c160:b029:f789:9f20:6eb8]) by resomta-a1p-076786.sys.comcast.net with ESMTPA id aKOAp896dPtTMaKOBpGTTE; Thu, 09 Mar 2023 17:49:16 +0000 X-Xfinity-VMeta: sc=-49.00;st=legit Content-Type: multipart/alternative; boundary=Apple-Mail-CEC33984-A111-4685-966A-075742E95D0A Content-Transfer-Encoding: 7bit From: Jwiencek3 Mime-Version: 1.0 (1.0) Subject: Re: postgresql to Oracle database migration Date: Thu, 9 Mar 2023 11:49:03 -0600 Message-Id: <3CF2F4B3-BAED-4118-B5C0-C52446151318@comcast.net> References: Cc: Holger Jakobs , pgsql-admin@lists.postgresql.org In-Reply-To: To: Sumit Sengupta X-Mailer: iPad Mail (20D67) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-CEC33984-A111-4685-966A-075742E95D0A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable The curious side of me would like to know w= hat made you decide to migrate from postgresql to oracle? Seems the tr= end now-a-days is the reverse. Do you have a really large budget you n= eed to eat up?

Sent from my iPad

On Mar 9, 2023, at 7:09 AM, Sumit Sengupta &= lt;ssengupta@hotmail.com> wrote:

=EF=BB=BF
Also Oracle considers zero byte character space as Null although they recomm= end not to assume it will stay that way. Here is a short blog comparing Oracle, Postges, MySQL and SQL Server around Nulls. =

From: Holger Jakobs
Sent: Thursday, March 9, 2023 4:48 AM
To: pgsql-admin@lists.postgresql.org
Subject: Re: postgresql to Oracle database migration

Am 09.03.23 um 10:46 schrieb Renjith Gk:
> Hi,
>
> Can anyone confirm any online tool or best practice to migrate
> postgresql queries to Oracle, there are few syntax differences
> compared from postgresql to Oracle
>
> Best regards,
> Renjith

There is no easy solution because Postgres' SQL dialect is a lot richer
= than Oracle's.

Most trivial queries will work immediately.

Kind regards,

Holger

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

= --Apple-Mail-CEC33984-A111-4685-966A-075742E95D0A--