Axborot texnologiyalari va kommunikatsiyalarini rivojlantirish vazirligi muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti amaliy topshiriq №13,14 Bajardi

Download 292.47 Kb.
Sana	20.06.2023
Hajmi	292.47 Kb.
	#74646

Bog'liq
ma\'lumot baza 4
Cho\'yan va uning sinflanishi, 1 октября День учителей наставников, 2 5197680374062262003, 1-мат анализ, reyting-daftar-303191100351, 18-v, muxlisa 10 Algebra yillik konspekt kompitensiyaviy, Marketing asoslari (N.Mo\'minov, F.Azimova, O.Shmugin), 1-Mavzu Mavzu Kirish. Fanning tarkibi mazmuni va elektr manba t-fayllar.org, 123456, l6igUSrAf0bghMBVSjZFL58gvePMrO0DbXmkUM89, Mavzu Jahon bozori va uning shakllari rejalar kirish i-bob. Ja-fayllar.org, Mamur Ro\'zibek, 208507065

Tasavvur (VIEW) yaratish va undan foydalanish 14-amaliy ish SQLda protseduralar yaratish

AXBOROT TEXNOLOGIYALARI VA KOMMUNIKATSIYALARINI RIVOJLANTIRISH VAZIRLIGI MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENT AXBOROT TEXNOLOGIYALARI UNIVERSITETI
AMALIY TOPSHIRIQ
№13,14

Bajardi: 219/21-guruh talabasi:Rasulov S.
Tekshirdi: Yuldashov .R

TOSHKENT – 2023

13-amaliy ish
Tasavvur (VIEW) yaratish va undan foydalanish

14-amaliy ish
SQLda protseduralar yaratish

select * from oquvchilar;

create view unsinf as select id,sinfi,ismi,familyasi from oquvchilar;
select * from unsinf;
drop view if exists un;
create view un as select id,ismi,familyasi from oquvchilar where sinfi=10;
select * from un;
drop view if exists un;

Select * from oqituvchilar;

create or replace procedure username_edit(old_name varchar, new_name varchar)
language plpgsql
as
$$
begin
update oqituvchilar set ismi=new_name where ismi=old_name;
end;
$$
Select * from oqituvchilar;

call username_edit('Ahad','kamol');

Download 292.47 Kb.