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 in 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
@@@

Have more questions? Submit a request

Comments