Untitled

                Never    
SQL
       
ALTER TABLE BUDYNEK
ADD POJ_SALI NUMBER(4);

ALTER TABLE PRZEDMIOT
MODIFY ECTS NUMBER(2);

ALTER TABLE PRZEDMIOT
MODIFY ECTS NOT NULL;

ALTER TABLE STYPENDIUM
ADD CHECK (KWOTA>50 OR KWOTA<5000);

ALTER TABLE OCENA
ADD CHECK (OCENA > 0);

ALTER TABLE ADRES
DROP COLUMN KODPOCZTOWY;

COMMENT ON TABLE STYPENDIUM
IS 'TO JEST STYPENDIUM';

SELECT COMMENTS FROM user_tab_comments WHERE TABLE_NAME = 'STYPENDIUM';

COMMENT ON COLUMN STYPENDIUM.KWOTA
IS 'KOMENTARZ FAJNY';

SELECT COMMENTS FROM USER_COL_COMMENTS 
WHERE TABLE_NAME = 'STYPENDIUM' AND COLUMN_NAME = 'KWOTA';
Update Stypendium
set KWOTA = KWOTA*0.9
where stypendium.id_student in 
(select student.id_student from student, ocena
where student.id_student = ocena.id_student and ocena.ocena < (select avg(ocena) from ocena));

3
update Stypendium
set KWOTA = KWOTA+150
where stypendium.id_student in
(select s.id_student
from student s, grupa g
where g.id_grupa = s.id_grupa and g.id_grupa in
(select g.id_grupa
from grupa g, zajecia z
where g.ID_GRUPA = z.id_grupa
group by g.id_grupa
order by count(z.id_zajecia) desc
fetch first row only));

5
update przedmiot
set ECTS = ECTS - 1
where id_przedmiot in
(select distinct p.id_przedmiot
from przedmiot p, zajecia z, grupa g, student s
where z.id_przedmiotu = p.id_przedmiot and z.id_grupa = g.id_grupa and g.id_grupa = s.id_grupa and s.id_student in
(select s.id_student
from student s
where s.nralbumu > 85351 and s.nralbumu < 86493));

4
select 
select p.id_przedmiot, p.ects
from przedmiot p
order by p.ects desc
fetch first 5 rows only

Raw Text