Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

The following code provides a breakdown of the basic SELECT statement on the Oracle platform

SELECT  [hint] [ DISTINCT | ALL ] <select_list> FROM <table_reference> [WHERE <condition>] [START WITH <condition> CONNECT BY <condition>] [GROUP BY <elements> ] [HAVING <condition> ] [ORDER BY <elements> ] --