Yes. The SQL query for an Oracle database in SearchBlox should follow the Oracle database standard.
* 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