RE: Any tips for switching between programming languages

From: <>
Date: Tue, 22 Sep 2020 09:27:24 -0700
Message-ID: <2bd401d690fd$41830700$c4891500$>

For some it is easier to take the conversion route.

Code in your primary language then convert the code to the secondary language. Once you start comparing languages you will find conversion patterns are fairly simple.    

From: <> On Behalf Of kunwar singh Sent: Tuesday, September 22, 2020 9:17 AM To: Stefan Knecht <> Cc: ORACLE-L <> Subject: Re: Any tips for switching between programming languages  

This is great, thank you so much!  

On Mon, Sep 21, 2020 at 11:25 PM Stefan Knecht < <> > wrote:

It's tricky.  

I've had days that start with ANSI SQL and python, followed by Oracle SQL and PL/SQL with Javascript/JQuery and ended with C# and LUA.  

It's inevitable that you'll use a single where you should use a double quote or end up with a semicolon to terminate a python line.  

What I found to help is to take a conscious break - say take a 5 minute walk - and imagine yourself switching jobs during that. Eventually you'll get used to it.  

If you have friends that speak different languages you can also practise this. It felt very similar to me when me and the wife had dinner with two couples - one spoke French, the other English and Thai with the wife. The act of switching is actually similar to switching programming languages on the fly, and particularly if you don't use a certain language that often (like me with French) - it also helps to try and flick an actual switch in your mind to trick yourself into adapting to it better.  

But mostly - don't sweat it. I just very recently realized that my muscle memory seems to be stronger than my conscious mind. After 20 years of Oracle, the string data type that my fingers want to type is varchar2. It doesn't matter that I am totally and completely aware of the fact that postgres doesn't use varchar2 but varchar - I will each and every single time find myself typing varchar2 and deleting the "2". And yes, as I typed that sentence, I had to delete a few "2"s.    


On Tue, 22 Sep 2020, 01:15 kunwar singh, < <> > wrote:

Hi Listers,

How do you guys manage to switch between many languages?  

When I program in bash I get a feeling that python is foreign to me. Any tips that you can suggest? I would really appreciate it.

I am DBA and not a full-time developer :)  





Received on Tue Sep 22 2020 - 18:27:24 CEST

Original text of this message