In this post we will see an example model for Objection.js and how we can define basic database concepts to our model. Objection.js is a relational query builder for Nodejs and is built on top of the Knex SQL query builder.
Drop all database objects in Oracle
In this article we will see a SQL script that will drop all objects in an Oracle database
Convert Long raw fields to varchar2 in Oracle with plain SQL
Oracle has a LONG RAW datatype that is used primarily in its system tables. There are cases where these tables need to be read from an application. There is a catch though, the common methods used to cast a datatype to another cannot be used in a plain SQL statement, but the developer must use […]