This would work for you, in Oracle.
SELECT *
FROM table_name
WHERE column_name > (SELECT AVG(column_name) FROM table_name)
You need to select a value to compare against, select the average value and then compare against the column you want to get. For more using
AVG()
function in Oracle SQL, read
this Stack Overflow thread[
^].