Registry for Multi Language Setup in Oracle Report Builder

Windows --> Start --> Run --> REGEDIT.


find 'NLS_LANG' and make the same id for all the places of NLS_LANG, then it will work for the languages like:


English, Arabic ( As I tested)


Issue was:


When I am passing the Arabic words in the Query it was displaying "?" question marks, instead of data, to over come this, I have done above changes in Registry, so it is working. 

SQL Query to find duplicate values in a table

SQL Query to find duplicate values in a table


SELECT
col,
COUNT(col)
FROM.
table_name.
GROUP BY col.
HAVING COUNT(col) > 1;