Does the Oracle query syntax vary from the queries of other databases in SearchBlox?

Yes. The SQL query for an Oracle database in SearchBlox should follow the Oracle database standard.

For example: 

* Oracle reserved words cannot be used in the query.
* ";" should not be given at the end of the query
* SQL query with the syntax given below does not work in Oracle.

select *, no as "uid" from sample

Also, while assigning a column name it is mandatory to give it in quotes as in the query below:

select no as "uid", title as "title" from sample

To learn more about SearchBlox please visit our developer document site

Have more questions? Submit a request