use clause oracle keyword code example

Example 1: oracle: using statement

SELECT table1.column, table2.column
FROM table1
JOIN table2 USING (join_column1, join_column2…);

Example 2: oracle: using statement

SQL> SELECT location_id, street_address, postal_code, country_name
  2  FROM locations
  3  JOIN countries
  4  USING (country_id);