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