Encontrar toda la informacion del departamento;
SELECT d.DEPARTMENT_ID, d.DEPARTMENT_NAME, r.REGION_NAME, l.STATE_PROVINCE, c.COUNTRY_NAME FROM departments d, regions r, locations l, countries c
WHERE d.LOCATION_id = l.LOCATION_id and l.COUNTRY_ID = c.COUNTRY_ID and r.region_id=c.region_id;
DEPARTMENT_ID
DEPARTMENT_NAME
REGION_NAME
STATE_PROVINCE
COUNTRY_NAME
10
Administration
Americas
Washington
United States of America
20
Marketing
Americas
Ontario
Canada
50
Shipping
Americas
California
United States of America
60
IT
Americas
Texas
United States of America
80
Sales
Europe
Oxford
United Kingdom
90
Executive
Americas
Washington
United States of America
110
Accounting
Americas
Washington
United States of America
190
Contracting
Americas
Washington
United States of America
8 rows [...]
Archivado bajo: BASE DE DATOS | Etiquetado: oracle, ejemplo, table, consulta, department | Deja un Comentario »