HI

Using clause is some thing like that we dont need to mention the join condition when we r retreiveing data from the multiple tables.when we use using clause that particular column name shud present in both the tables and the select query will automatically join those tables using the given column name in USING clause.

Hi

The using clause in Oracle is to support ANSI standard SQL for writing joins.

The same query can be written in the form of

SELECT emp_name department_name city
FROM employees e departments d locations l
WHERE d.department_id e.department_id
AND d.location_id l.location_id
AND salary > 10000

Guna Sagar Challa

for e.g. if there are two common column names in the table then Mention the desire common column name in the USING clause....