> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oxla.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Reference

This section provides information about the syntax and semantics of SQL queries, clauses, data types, and functions that Oxla supports. The information in this section is divided into groups according to the kind of operation they perform as follows:

<CardGroup cols={3}>
  <Card
    title="SQL Statements"
    icon={<svg id="Layer_2" data-name="Layer 2" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75 74.99">
<g id="Layer_1-2" data-name="Layer 1">
<g>
  <rect class="cls-1" x="16.67" y="66.66" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="16.66" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="25" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" y="66.66" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" width="8.33" height="8.33"/>
  <rect class="cls-1" x="50" y="66.66" width="8.34" height="8.33"/>
  <rect class="cls-1" x="50" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="66.66" width="8.33" height="8.33"/>
  <rect class="cls-1" x="41.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="41.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="66.66" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" y="66.66" width="8.34" height="8.33"/>
  <rect class="cls-1" x="25" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="25" width="8.34" height="8.33"/>
  <rect class="cls-1" x="16.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="66.66" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" width="8.33" height="8.33"/>
  <rect class="cls-1" y="58.33" width="8.34" height="8.33"/>
  <rect class="cls-1" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" y="41.66" width="8.34" height="8.34"/>
  <rect class="cls-1" y="25" width="8.34" height="8.33"/>
  <rect class="cls-1" y="16.66" width="8.34" height="8.34"/>
  <rect class="cls-1" y="8.33" width="8.34" height="8.33"/>
</g>
</g>
</svg>}
    href="/sql-reference/sql-statements/overview"
  >
    Learn how to create a request for data or information from one or more database tables using our supported statements.
  </Card>

  <Card
    title="SQL Clauses"
    icon={<svg id="Layer_2" data-name="Layer 2" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75 75">
<g id="Layer_1-2" data-name="Layer 1">
<g>
  <rect class="cls-1" x="33.34" y="66.66" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" y="41.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="41.67" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="50" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="58.34" y="25" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="25" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" width="8.33" height="8.33"/>
  <rect class="cls-1" x="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="41.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="41.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" y="66.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="25" y="58.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="25" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="25" width="8.34" height="8.33"/>
  <rect class="cls-1" x="16.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" width="8.33" height="8.33"/>
  <rect class="cls-1" y="16.66" width="8.34" height="8.34"/>
  <rect class="cls-1" y="8.33" width="8.34" height="8.33"/>
  <rect class="cls-1" width="8.34" height="8.33"/>
</g>
</g>
</svg>}
    href="/sql-reference/sql-clauses/overview"
  >
    This sub-section show you how to write user-friendly queries and analyze data using different
    constraints and conditions.
  </Card>

  <Card
    title="SQL Data Types"
    icon={<svg id="Layer_2" data-name="Layer 2" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75 75">
<g id="Layer_1-2" data-name="Layer 1">
<g>
  <rect class="cls-1" x="25" y="66.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="25" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="25" y="58.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="41.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="41.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="50" y="16.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="16.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="16.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="58.34" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="58.34" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="50" y="66.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="66.67" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="50" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" y="58.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="16.67" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" y="66.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="8.34" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="16.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="8.34" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="50" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="25" y="16.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="33.34" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="50" y="8.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="25" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" width="8.34" height="8.33"/>
  <rect class="cls-1" x="16.67" y="8.33" width="8.33" height="8.33"/>
</g>
</g>
</svg>}
    href="/sql-reference/sql-data-types/overview"
  >
    This sub-section will guide you through implementing our supported data types to run your operations, such as text, timestamp, numeric, and many more…
  </Card>

  <Card
    title="SQL Functions"
    icon={<svg id="Layer_2" data-name="Layer 2" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75 75">
<g id="Layer_1-2" data-name="Layer 1">
<g>
  <rect class="cls-1" x="25" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="33.34" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="41.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="58.34" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="50" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="33.34" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" width="8.34" height="8.33"/>
  <rect class="cls-1" x="16.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="16.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="25" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="16.67" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="8.34" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" y="66.66" width="8.34" height="8.34"/>
</g>
</g>
</svg>}
    href="/sql-reference/sql-functions/overview"
  >
    See how you can combine the statements, data types, and other references into specific functions for particular tasks.
  </Card>

  <Card
    title="Schema"
    icon={<svg id="Layer_2" data-name="Layer 2" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75 75">
<g id="Layer_1-2" data-name="Layer 1">
<g>
  <rect width="8.33" height="8.33"/>
  <rect y="66.66" width="8.33" height="8.34"/>
  <rect x="66.67" y="66.66" width="8.33" height="8.34"/>
  <rect x="66.67" width="8.33" height="8.33"/>
  <rect x="33.33" y="50" width="8.34" height="8.33"/>
  <rect x="50" y="33.33" width="8.33" height="8.33"/>
  <rect x="16.67" y="33.33" width="8.33" height="8.33"/>
  <rect x="33.33" y="16.66" width="8.34" height="8.34"/>
  <rect x="58.33" y="58.33" width="8.34" height="8.33"/>
  <rect x="8.33" y="58.33" width="8.34" height="8.33"/>
  <rect x="8.33" y="8.33" width="8.34" height="8.33"/>
  <rect x="58.33" y="8.33" width="8.34" height="8.33"/>
  <rect x="50" y="50" width="8.33" height="8.33"/>
  <rect x="41.67" y="41.66" width="8.33" height="8.34"/>
  <rect x="16.67" y="50" width="8.33" height="8.33"/>
  <rect x="25" y="41.66" width="8.33" height="8.34"/>
  <rect x="16.67" y="16.66" width="8.33" height="8.34"/>
  <rect x="25" y="25" width="8.33" height="8.33"/>
  <rect x="50" y="16.66" width="8.33" height="8.34"/>
  <rect x="41.67" y="25" width="8.33" height="8.33"/>
  <rect x="33.33" y="8.33" width="8.34" height="8.33"/>
  <rect x="58.33" y="33.33" width="8.34" height="8.33"/>
  <rect x="8.33" y="33.33" width="8.34" height="8.33"/>
  <rect x="33.33" y="58.33" width="8.34" height="8.33"/>
  <rect x="33.33" y="66.66" width="8.34" height="8.34"/>
  <rect y="33.33" width="8.33" height="8.33"/>
  <rect x="66.67" y="33.33" width="8.33" height="8.33"/>
  <rect x="33.33" width="8.34" height="8.33"/>
  <rect x="41.67" y="33.33" width="8.33" height="8.33"/>
  <rect x="33.33" y="41.66" width="8.34" height="8.34"/>
  <rect x="33.33" y="25" width="8.34" height="8.33"/>
  <rect x="25" y="33.33" width="8.33" height="8.33"/>
</g>
</g>
</svg>}
    href="/sql-reference/schema"
  >
    Learn about a logical container that holds database objects and relationships of data in a database.
  </Card>

  <Card
    title="Comment Support"
    icon={<svg id="Layer_2" data-name="Layer 2" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75 75">
<g id="Layer_1-2" data-name="Layer 1">
<g>
  <rect class="cls-1" x="16.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="16.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="25" y="16.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="41.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="50" y="16.66" width="8.34" height="8.34"/>
  <rect class="cls-1" x="66.67" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="25" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" width="8.33" height="8.33"/>
  <rect class="cls-1" x="50" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="41.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" x="25" width="8.34" height="8.33"/>
  <rect class="cls-1" x="16.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" width="8.33" height="8.33"/>
  <rect class="cls-1" y="41.66" width="8.34" height="8.34"/>
  <rect class="cls-1" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" y="25" width="8.34" height="8.33"/>
  <rect class="cls-1" y="16.66" width="8.34" height="8.34"/>
  <rect class="cls-1" y="8.33" width="8.34" height="8.33"/>
</g>
</g>
</svg>}
    href="/sql-reference/comment-support"
  >
    Adding comments in your queries for better documentation and collaboration.
  </Card>

  <Card
    title="Transactions"
    icon={<svg id="Layer_2" data-name="Layer 2" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75 75">
<g id="Layer_1-2" data-name="Layer 1">
<g>
  <rect x="41.67" y="66.66" width="8.33" height="8.34"/>
  <rect x="50" y="58.33" width="8.33" height="8.33"/>
  <rect x="58.33" y="50" width="8.34" height="8.33"/>
  <rect x="25" width="8.33" height="8.33"/>
  <rect x="16.67" y="8.33" width="8.33" height="8.33"/>
  <rect x="8.33" y="16.66" width="8.34" height="8.34"/>
  <rect x="66.67" y="41.66" width="8.33" height="8.34"/>
  <rect x="58.33" y="41.66" width="8.34" height="8.34"/>
  <rect x="50" y="41.66" width="8.33" height="8.34"/>
  <rect x="41.67" y="41.66" width="8.33" height="8.34"/>
  <rect x="33.33" y="41.66" width="8.34" height="8.34"/>
  <rect x="25" y="41.66" width="8.33" height="8.34"/>
  <rect y="41.66" width="8.33" height="8.34"/>
  <rect x="16.67" y="41.66" width="8.33" height="8.34"/>
  <rect x="8.33" y="41.66" width="8.34" height="8.34"/>
  <rect x="66.67" y="25" width="8.33" height="8.33"/>
  <rect x="58.33" y="25" width="8.34" height="8.33"/>
  <rect x="50" y="25" width="8.33" height="8.33"/>
  <rect x="41.67" y="25" width="8.33" height="8.33"/>
  <rect x="33.33" y="25" width="8.34" height="8.33"/>
  <rect x="25" y="25" width="8.33" height="8.33"/>
  <rect x="8.33" y="25" width="8.34" height="8.33"/>
  <rect y="25" width="8.33" height="8.33"/>
  <rect x="16.67" y="25" width="8.33" height="8.33"/>
</g>
</g>
</svg>}
    href="/sql-reference/transactions"
  >
    Learn more about managing your transactions.
  </Card>

  <Card
    title="SQL Mutations"
    icon={<svg id="Layer_2" data-name="Layer 2" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 75 75">
<g id="Layer_1-2" data-name="Layer 1">
<g>
  <rect class="cls-1" x="66.67" y="66.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="50" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" y="16.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="66.67" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="66.67" width="8.33" height="8.33"/>
  <rect class="cls-1" x="58.34" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="58.34" y="25" width="8.33" height="8.33"/>
  <rect class="cls-1" x="50" y="58.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="50" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="50" y="8.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="41.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="41.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="41.67" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="33.34" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="25" y="58.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="25" y="33.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="25" y="8.33" width="8.34" height="8.33"/>
  <rect class="cls-1" x="16.67" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="33.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="16.67" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="58.33" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="41.66" width="8.33" height="8.34"/>
  <rect class="cls-1" x="8.34" y="25" width="8.33" height="8.33"/>
  <rect class="cls-1" x="8.34" y="8.33" width="8.33" height="8.33"/>
  <rect class="cls-1" y="66.66" width="8.34" height="8.34"/>
  <rect class="cls-1" y="58.33" width="8.34" height="8.33"/>
  <rect class="cls-1" y="50" width="8.34" height="8.33"/>
  <rect class="cls-1" y="16.66" width="8.34" height="8.34"/>
  <rect class="cls-1" y="8.33" width="8.34" height="8.33"/>
  <rect class="cls-1" width="8.34" height="8.33"/>
</g>
</g>
</svg>}
    href="/sql-reference/sql-mutations/overview"
  >
    Modify your existing data with data manipulation.
  </Card>
</CardGroup>