End-to-End Example

1. Create a table

1.1. Create a new table.

2. Desc the table created

2.1. Get a list of tables in a compartment.2.2. Get table info by identifier.

3. CRUD operations on the table created

3.4. Write a single row into the table.3.2. Get a single row from the table by primary key.3.3. Delete a single row from the table, by primary key.

4. Query Operations on the table created

4.1. Execute a SQL query.4.2. Check the syntax and return a brief summary of a SQL statement.

5. Index Operations on the table created

5.1. Create a new index.5.2. Get a list of indexes on a table.

6.2. Delete a table by tableNameOrId. Copy

NoSQL Database API

Execute a SQL query.Prepare a SQL statement for use in a query with variable substitution. Check the syntax and return a brief summary of a SQL statement.

tables-{tableNameOrId}-indexes-{indexName}

Delete an index.Get information about a single index.

tables-{tableNameOrId}-indexes

Get a list of indexes on a table.Create a new index.

tables-{tableNameOrId}-rows

Delete a single row from the table, by primary key.Get a single row from the table by primary key.Write a single row into the table.

tables-{tableNameOrId}

Delete a table by tableNameOrId.Get table info by identifier.Alter the table identified by tableNameOrId.Change a table's compartment.Get table usage info.

Get a list of tables in a compartment.Create a new table.

workRequests-{workRequestId}

Cancel a work request operation with the given ID.Get the status of the work request with the given ID.List work request errors Lists work request logs

List the work requests in a compartment.

End-to-End Example

1. Create a table

1.1. Create a new table.

2. Desc the table created

2.1. Get a list of tables in a compartment.2.2. Get table info by identifier.

3. CRUD operations on the table created

3.4. Write a single row into the table.3.2. Get a single row from the table by primary key.3.3. Delete a single row from the table, by primary key.

4. Query Operations on the table created

4.1. Execute a SQL query.4.2. Check the syntax and return a brief summary of a SQL statement.

5. Index Operations on the table created

5.1. Create a new index.5.2. Get a list of indexes on a table.

6.2. Delete a table by tableNameOrId. Copy

NoSQL Database API

Execute a SQL query.Prepare a SQL statement for use in a query with variable substitution. Check the syntax and return a brief summary of a SQL statement.

tables-{tableNameOrId}-indexes-{indexName}

Delete an index.Get information about a single index.

tables-{tableNameOrId}-indexes

Get a list of indexes on a table.Create a new index.

tables-{tableNameOrId}-rows

Delete a single row from the table, by primary key.Get a single row from the table by primary key.Write a single row into the table.

tables-{tableNameOrId}

Delete a table by tableNameOrId.Get table info by identifier.Alter the table identified by tableNameOrId.Change a table's compartment.Get table usage info.

Get a list of tables in a compartment.Create a new table.

workRequests-{workRequestId}

Cancel a work request operation with the given ID.Get the status of the work request with the given ID.List work request errors Lists work request logs

List the work requests in a compartment.

Home End-to-End Example6. Clean Up

6. Clean Up

Number of APIs: 1

6.2. Delete a table by tableNameOrId. Copy DELETE {{baseUrl}}/tables/:tableNameOrId?compartmentId={{compartment_ocid}}&isIfExists=false

5.2. Get a list of indexes on a table.

6.2. Delete a table by tableNameOrId. Copy