5. gyakorlat

SELECT
    rowid,
    dnev,
    dbms_rowid.rowid_object(rowid) "objektum azonosító",
    dbms_rowid.rowid_relative_fno(rowid) "fájl",
    dbms_rowid.rowid_block_number(rowid) "blokk",
    dbms_rowid.rowid_row_number(rowid) "sor"
    FROM nikovits.dolgozo WHERE dnev = 'KING';

SELECT * FROM dba_objects WHERE object_id = 73727;
SELECT * FROM dba_data_files WHERE file_id = 7;

SELECT * FROM nikovits.emp;

SELECT * FROM dba_indexes WHERE owner = 'NIKOVITS' and table_name = 'EMP';
SELECT * FROM dba_ind_columns WHERE index_name = 'EMP2' AND index_owner = 'NIKOVITS';
SELECT * FROM dba_ind_expressions WHERE index_owner = 'NIKOVITS' AND index_name = 'EMP2';

SELECT * FROM dba_part_tables;

1. feladat

Adjuk meg azoknak a tábláknak a nevét, amelyeknek van csökkenő sorrendben indexelt oszlopa

SELECT DISTINCT table_owner, table_name FROM dba_ind_columns WHERE descend = 'DESC';

2. feladat

Adjuk meg azoknak az indexeknek a nevét, amelyek legalább 9 oszloposak.

SELECT index_owner, index_name, count(column_name) db
FROM dba_ind_columns
GROUP BY index_owner, index_name
HAVING count(column_name) >= 9;

3. feladat

Hozzunk létre egy indexet a dolgozo tábla oazon oszlopára

CREATE INDEX oazonind ON dolgozo(oazon);
SELECT * FROM dba_indexes WHERE index_name = 'OAZONIND';