際際滷

際際滷Share a Scribd company logo

Base de Datos

C
Carla Ysolina

This document provides descriptions of tables in a database and sample SELECT statements to view the data in each table. The tables described are countries, departments, employees, jobs, job_grades, job_history, locations, and regions. SELECT statements are provided to view the data in each table.

1 of 10
Table Descriptions and Data Additional Practices
COUNTRIES Table DESCRIBE countries SELECT * FROM countries;
DEPARTMENTS Table DESCRIBE departments SELECT * FROM departments;
EMPLOYEES Table DESCRIBE employees SELECT * FROM employees;
EMPLOYEES Table (continued)
JOBS Table DESCRIBE jobs SELECT * FROM jobs;
JOB_GRADES Table DESCRIBE job_grades SELECT * FROM job_grades;
JOB_HISTORY Table DESCRIBE job_history SELECT * FROM job_history;
LOCATIONS Table DESCRIBE locations SELECT * FROM locations;
REGIONS Table DESCRIBE regions SELECT * FROM regions;

More Related Content

Base de Datos

  • 1. Table Descriptions and Data Additional Practices
  • 2. COUNTRIES Table DESCRIBE countries SELECT * FROM countries;
  • 3. DEPARTMENTS Table DESCRIBE departments SELECT * FROM departments;
  • 4. EMPLOYEES Table DESCRIBE employees SELECT * FROM employees;
  • 5. EMPLOYEES Table (continued)
  • 6. JOBS Table DESCRIBE jobs SELECT * FROM jobs;
  • 7. JOB_GRADES Table DESCRIBE job_grades SELECT * FROM job_grades;
  • 8. JOB_HISTORY Table DESCRIBE job_history SELECT * FROM job_history;
  • 9. LOCATIONS Table DESCRIBE locations SELECT * FROM locations;
  • 10. REGIONS Table DESCRIBE regions SELECT * FROM regions;