Posted by: WakkaDikka22 March 19, 2016
Oracle simple help
Login in to Rate this Post:     0       ?        
SELECT DISTINCTcolumn_name,column_name
FROM table_name;

SELECT * From table_name;

Please understand (*) will return everything, hence DISTINCT *(everything) is a wrong sql statement.
DISTINCT specifically looks for unique result set,,The DISTINCT keyword can be used to return only distinct (different) values
Read Full Discussion Thread for this article