@import url("https://fonts.googleapis.com/css2?family=Space+Grotesk:wght@300..700&display=swap");body {
  font-family: "Space Grotesk", sans-serif;
}

.dark p {
  color: white;
}

.ring-transparent {
  transition: 0.5s ease-in-out;
}

.ring-transparent:hover {
  box-shadow: 1px 1px 21px -1px rgba(49, 57, 219, 0.64);
  -webkit-box-shadow: 1px 1px 21px -1px rgba(49, 57, 219, 0.64);
  -moz-box-shadow: 1px 1px 21px -1px rgba(49, 57, 219, 0.64);
}

:is(.dark .dark\:bg-codeblock\/50) {
  filter: brightness();
}

:is(.dark .dark\:bg-codeblock\/50) svg {
  filter: brightness(10);
}

:is(.dark .dark\:bg-codeblock\/50):hover {
  filter: brightness(10);
}

:is(.dark .dark\:text-primary-light) {
  color: rgb(152 157 255);
}

/* for white color in dark mode */
.prose:is(.dark *) {
  color: white;
}

/* for black color in light mode */
.prose {
  color: black;
}

/* for a clearer code format in dark mode */
:not(pre) > code:is(.dark *) {
  background: transparent;
  border-width: 0;
}

/* for a clearer code format in light mode */
:not(pre) > code {
  background: transparent;
  border-width: 0;
}


What is a Statement? 🤨

How does a Statement work? 🧐

Oxla Developer Hub

Product

Blog

Changelog

Overview

Discover everything you need to know about Oxla right here, right now!

Welcome

Key Concepts & Architecture

OLTP vs OLAP

Oxla vs. Other OLAP Solutions

Our Key Features

Run Oxla in 2 minutes

Run Oxla on S3

Multi-node Deployment

Run Oxla via AWS

Run Oxla on Google Cloud Storage

Run Oxla on Azure Blob Storage

Introduction to Oxla Cloud

Quickstart - Oxla SaaS

How to Connect Oxla Cloud with TablePlus

How to Connect Oxla Cloud with Looker Studio

How to Connect Oxla Cloud with PowerBI

Introduction

eCommerce Dataset

Web Traffic Dataset

Urban Mobility Dataset

Social Media Dataset

SQL TABLE

CREATE INDEX statement

SELECT statement

INSERT INTO statement

DROP statement

SHOW TABLES statement

DESCRIBE statement

SHOW NODES statement

SET/SHOW statement

WHERE

GROUP BY

HAVING

ORDER BY

LIMIT

OFFSET

Data Type Operators

Bool Type

Date Type

Timestamp Without Time Zone Type

Timestamp with Time Zone

Interval Type

Text Type

JSON Type

Trigonometric Functions

Schema

Comment Support

Mutation - UPDATE

Mutation - DELETE

pg_description

pg_settings

pg_index

pg_namespace

pg_attrdef

pg_depend

pg_constraint

pg_statio_user_tables

C# Dapper - Npgsql

JAVA JDBC

PHP PDO

Error Handling

Differences Between Oxla vs. PostgreSQL

Understanding Transactions

Database Files Virtual Table

Data Task Stability

Handling Oxla Degraded State

Public Metrics

Oxla Configuration File

Introduction

Getting Started

Oxla Cloud (SaaS)

SQL Reference

SQL Mutations

System Catalogs

Integrations

Resources

Overview

What is a Statement? 🤨

How does a Statement work? 🧐

CREATE TABLE Statement

CREATE INDEX Statement

DROP Statement

SELECT Statement

INSERT INTO Statement

SHOW TABLES Statement

DESCRIBE Statement

SHOW NODES Statement

SET/SHOW Statement

COPY FROM Statement

COPY TO Statement

Introduction

Getting Started

Oxla Cloud (SaaS)

SQL Reference

SQL Mutations

System Catalogs

Integrations

Resources

​What is a Statement? 🤨

​How does a Statement work? 🧐

CREATE TABLE Statement

CREATE INDEX Statement

DROP Statement

SELECT Statement

INSERT INTO Statement

SHOW TABLES Statement

DESCRIBE Statement

SHOW NODES Statement

SET/SHOW Statement

COPY FROM Statement

COPY TO Statement

What is a Statement? 🤨

How does a Statement work? 🧐