Good day. Please tell me possible solutions to the problem:
There is a table where the last name and first name and other data are stored, in some records the last name and first name are mixed up (for example, in the last name column – first name). DB – Oracle.

I want to use Ora2Pg too import a Oracle bd, including the script provided too recreate all object. I am seeking advice or recommandations for its use

I am currently engaged in learning to formulate queries on the Datalemur platform.

I am trying to write a query on datalemur but my solution is not getting accepted