ORA-00907 missing right parenthesis

Cause: A left parenthesis has been entered without a closing right parenthesis, 

       or extra information was contained in the parentheses. All parentheses must be entered in pairs.

SOLUTION:

1. Dont Give Order by in table query.

2. Check Both side the Parenthesis

3.Correct the syntax and retry the statement.

2.       DON’T GIVE ORDER BY IN SELECT QUERY (order by carrier_name)

DON’T GIVE LIKE BELOW

(select distinct carrier_name from wsh_carriers_v where carrier_name is not null group by carrier_name order by carrier_name)x

GIVE LIKE BELOW

select distinct carrier_name from wsh_carriers_v   where carrier_name is not null group by carrier_name) x