Laborator 1 SGBD

select * from tabs;

--11
COMMENT ON TABLE emp_OSA IS 'Informaţii despre angajati';

--12
desc user_tab_comments

--13
select *
from user_tab_comments
where table_name='EMP_OSA';


ALTER SESSION SET NLS_DATE_FORMAT = 'dd mon yyyy hh24:mi:ss';

select sysdate from dual;

--14
SELECT to_number(YEAR FROM SYSDATE)
FROM dual;

--15
select * from emp_osa
--where EXTRACT(month FROM hire_date)=5;
where to_char(hire_date, 'fmmm')=5;--fm scoate caracterele de completare

--16
desc user_tables
select table_name
where table_name like '%prof'

--17
select 'drop table '||table_name||';'
from user_tables;--tocmai am intergoat dictionarul datelor


SPOOL OFF
SET PAGESIZE 0
SPOOL d:/sterg_tabele.sql