SQL Reference
SQL Data Types
JSON Type
7min
JSON stands for JavaScript Object Notation. It is an open standard format with key-value pairs to transport data between a server and a web application.
The JSON data type in Oxla has the following syntax:
First, create the orders table using the below command:
This will create a table with the orders_Detailcolumn to store key-value pairs of data.
Next, insert data into the orders table as follows:
This will insert data values where orders_Detailhas the following keys:
- customer: it will store a customer’s data who purchased the product.
- items: it will store the order details, product & qty.
Use the SELECT command to retrieve the orders table's data.
You will get the following output:
Note: It is normal for the JSON type’s result to look disordered.
Updated 09 Oct 2023

Did this page help you?