From the below tech tip, I can see there is DB connection provided for MSSQL and not for ORACLE database.
We are using Oracle DB. What are the equivalent statements for below to connect to ORACLE DB and run the query?
database.open("Provider=SQLOLEDB;Initial Catalog=CA_UIM;Data Source=<databaseserver>,1433;User ID=sa;Password=<databasepassword>;Network Library=dbmssocn;Language=us_english")
database.query("select * from nas_alarms WITH (NOLOCK) where robot = '"..a.robot.."' and (message like '%total cpu is now%' or message like '%processor queue length%')")