Previous Next JavaScript must be enabled to correctly display this content

## 12 Built-in Functions

This chapter discusses about the Built-in functions supported in Oracle NoSQL Database.

Most of the examples demonstrated in this section use one of the two common schemas, that is, the `BaggageInfo` table schema and `stream_acct` table schema.

The `BaggageInfo` table contains passenger details and bag information that is made available as a part of the airline application. The `stream_acct` table includes information about various shows that the customers watch and can be used on a TV streaming application.

If you want to use the common schema and follow along with the examples, download the scripts baggageschema_loaddata.sql and acctstream_loaddata.sql.

Start your KVSTORE or KVLite and open the SQL shell.

    java -jar lib/kvstore.jar kvlite -secure-config disable

    java -jar lib/sql.jar -helper-hosts localhost:5000 -store kvstore

Using the `load` command, run the required script.

Example:

    load -file baggageschema_loaddata.sql

    load -file acctstream_loaddata.sql

This creates the tables used in the examples and loads the data into the tables.

For more details on the common schema, see Getting started with SQL for Oracle NoSQL Database in the Developers Guide.

This chapter contains the following topics:

- Functions on Complex Values
- Functions on Sequences
- Functions on Timestamps
- Functions on Rows
- Function to generate a UUID string
- Functions on GeoJson Data
- Functions on Strings
- Function to Convert String to JSON
- Functions of Mathematical Operations