calling a procedure.
after the SQL procedure is created, you need to use the SQL caLL
statement to execute it. The caLL statement names the procedure that is called and lists all
required parameters that need to be passed to the procedure. optional parameters can be passed
on the caLL statement in any order. an SQL procedure must be called through an SQL caLL
statement. on the caLL statement, the name of the stored procedure must be the same as the
name that is specified on the creaTe procedure statement. arguments can be constants,
special registers, host variables, or expressions. When a procedure that contains inouT or ouT
parameters is called, the caller must be a procedure that contains local variables to receive the
results of the called procedure. SQL descriptors can be used instead of specifying individual
variables. The descriptor must be allocated large enough to contain all of the in and inouT
parameters that are defined by the called procedure. The inTo SQL deScripTor clause can
be used to receive the values for all of the parameters that are defined as inouT or ouT.
in conclusion, we’ve seen that the use of parameters can add a great deal of flexibility to
the process of retrieving data. for example, parameters allow us to generalize SQL statements
so that values for selection criteria can be specified at the time the statement is executed. The
basics of how to create and execute stored procedures were given.
11
Ноябрь 2020 16-қисм
Тошкент
TEXNOLOGIYA FANINING O’QUVcHILAR HAYOTIdAGI O’RNI
Jumayeva Gulbahor O’ktamovna
Navoiy viloyat, Qiziltepa tuman
13-umumiy o’rta ta’lim maktab
texnalogiya fani o’qituvchisi
o’quvchilar texnologiya fanini o’rganish orqali qo’shimcha daromad topish, o’zlari qo’l mehnati
orqali yasagan ajoyib narsalari uchun yuqori sifatli hunarning egasi bo’lish imkoniyatlariga ega
bo’ladilar.
ajoyib diY loyihalarini amalga oshirish uchun o’quvchilar rassom, tikuvchi yoki mutaxassis
hunarmand bo’lishi shart emas. odamlar shunchaki qo’lda ishlangan narsalarni yaxshi ko’radilar,
va ushbu ajoyib hunarmandchilik loyihalarini amalga oshirish uchun ko’p narsalarga ega bo’lish
yoki ularni sarflash shart bo’lmaydi. biz har qanday byudjetga mos keladigan ba’zi sevimli ijodiy
g’oyalarni birgalikda ishlashimiz mumkin.
1. Sarguzashtlar uchun daftar
ushbu sarguzashtlarga bag’ishlangan diY daftar styuardessa, o’qituvchidan tortib bolalargacha
bo’lganlar uchun eng yaxshi sovg’a g’oyasi! Shaxsiylashtirish uchun juda oddiy. Men har bir
farzandimning yil davomida shaxsiy daftariga ega bo’lish g’oyasini yaxshi ko’raman. ular undan
rasm chizish, g’oyalar va fikrlarni yozish uchun foydalanishi yoki kerak bo’lgan narsalarga rang
berishlari mumkin.
Qushlar uchun ajoyib ko’rinishdagi uychalarni yasash mumkin. bu uychalarning boshqalaridan
farqi uychalarning past qismiga kalit osish uchun turli shakllar qilish mumkin.
bu o’quvchidan ozgina kreativ va yaratuvchanlikni talab qiladi xolos.
o’quvchi texnologiya fanini o’rganish jarayonida o’zining yaratuvchanlik dunyosini ham
kengaytirib borishi mumkin.
Texnologiya fani yaratuvchanlikni oshiruvchi va boyituvchi fandir. oddiy ko’rinishdagi
narsalardan ajoyib ko’rinishdagi buyumlargacha yasash mumkin.
Xulosa o’rnida shuni aytish mumkinki, o’quvchilarni fanga qiziqtirish orqali ularning
dunyoqarashini kengaytirish mumkin.
foydalanilgan adabiyotlar ro’yxati:
1. Qo’l mehnatlari. ijtimoiy tarmoq ma’lumotlari.
12
Do'stlaringiz bilan baham: |