Interact with an Oracle database with Ballerina

The title pretty much explains the purpose! So, I’m moving on to the sample. We are using ballerinax/jdbc package here.

Ballerina version: 0.990.3
Oracle database version used: Oracle-xe-11g

Note: You need to copy the Oracle JDBC driver jar into $BALLERINA_HOME/bre/lib

Table creation query:

Sample:

How to run:

ballerina run oracle-0.990.3.bal

Output:

1.0|Harry|Potter|1000.0
2.0|Ron|Weasley|1000.0