This blog will help you to know the basic of oracle DataBase and some important clause of Data Base Objects.
SELECT Count(*) FROM ( SELECT DISTINCT Col1 , Col2 , Col3 FROM table_name ) As AAA