MySQL can support the JSON datatype, and allows to write queries that can query the JSON data directly. In the case where the JSON value is an array of objects, we will see how we can query the table and retrieve the JSON data as relational data. We will see how we can use JSON_TABLE […]
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 […]
Backup the data from your Sql Server
An often requirement in a CMS is the user to be able to backup the database of its CMS installation. If you are using MS Sql Server there is a simple command that creates a .bak file of your database. BACKUP DATABASE [mydb] TO DISK = N'<bak_file_path>’ Restoring the database is also simple with the […]