oracle select

오라클 공식 select 문법 구조
[링크 : http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10002.htm]
[링크 : http://docs.oracle.com/cd/B19306_01/server.102/b14200/img/subquery.gif] 

[ subquery_factoring_clause ] SELECT [ hint ] [ { { DISTINCT | UNIQUE } | ALL } ] select_list FROM { table_reference [, table_reference ]... | join_clause | ( join_clause ) } [ where_clause ] [ hierarchical_query_clause ] [ group_by_clause ] [ HAVING condition ] [ model_clause ] [ { UNION [ ALL ] | INTERSECT | MINUS } (subquery) ] [ order_by_clause ] [링크 : http://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/subquery.htm]

hierarchical

[ START WITH condition ]
CONNECT BY [ NOCYCLE ] condition
[링크 : http://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/hierarchical_query_clause.htm]

outer join

[ query_partition_clause ]
{ outer_join_type JOIN
| NATURAL [ outer_join_type ] JOIN
}
table_reference [ query_partition_clause ]
[ ON condition
| USING ( column [, column ]...)
]
[링크 : http://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/outer_join_clause.htm]



inner join
{ [ INNER ] JOIN table_reference
    { ON condition
    | USING (column [, column ]...)
    }
| { CROSS
  | NATURAL [ INNER ]
  }
  JOIN table_reference
}
[링크 : http://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/inner_cross_join_clause.htm]