/* @lstDat_UZ.sql */

column clvDpto    heading "idDpto"       format 999;
column codDpto    heading "acrDpto"      format a6 trunc;
column nombDpto   heading "Departamento" format a20 trunc;
column clvProf    heading "idProf"       format 999;
column codProf    heading "acrProf"      format a6 trunc;
column nombProf   heading "Profesor"     format a20 trunc;
column clvArea    heading "idArea"       format 9999;
column codArea    heading "acrArea"      format a6 trunc;
column nombArea   heading "Area Conoc."  format a20 trunc;
column HT         heading "Teoría"       format 999;
column HP         heading "Probl."       format 999;
column clvAsign   heading "idAsig"       format 999;
column codAsign   heading "acrAsign"     format a6 trunc;
column nombAsign  heading "Asignatura"   format a20 trunc;
column tt_HT      heading "H.T."         format 999;
column tt_HP      heading "H.P."         format 999;
column clvTitulo  heading "idTit"        format 999;
column codTitulo  heading "acrTitul"     format a6 trunc;
column nombTitulo heading "Titulación"   format a20 trunc;

SELECT COUNT(*) "nº Dptos" FROM Departamento;
SELECT * FROM Departamento;

SELECT COUNT(*) "nº areas" FROM AreaConoc;
SELECT * FROM AreaConoc;

SELECT COUNT(*) "nº Prof" FROM Profesor;
SELECT * FROM Profesor;

SELECT COUNT(*) "nº Asign" FROM Asignatura;
SELECT * FROM Asignatura;

SELECT COUNT(*) "nº Titul" FROM Titulacion;
SELECT * FROM Titulacion;

SELECT COUNT(*) "nº ImpAsg" FROM ImparteAsign;
SELECT * FROM ImparteAsign;

SELECT COUNT(*) "nº AsgTit" FROM AsignTitulo;
SELECT * FROM AsignTitulo;