|
=
SET TRANSACTION transaction mode> [ { transaction mode> }... ] transaction mode> ::=
|
| bet | 61/80 | | Sana | 05.01.2024 | | Hajmi | 281,59 Kb. | | #130407 |
Bog'liq 1-bob. Ma`lumotlar bazasining asosiy tushunchalari-fayllar.org::=
SET TRANSACTION transaction mode> [ { transaction mode> }... ] transaction mode> ::=
| access mode>
| «diagnostics size>
«isolation level> ::=
ISOLATION LEVEL «level of isolation>
of isolation> ::=
READ | SERIALIZAB1 1
transaction access mode>
READ ONLY | READ WRITE
diagnostics size> ::=
DIAGNOSTICS SIZE of conditions>
::=
Bu yerda:
Agar himoya darajalari ko‘rsatilmasa, himoya darajasi SERIALIZABLE deb tushuniladi.
Agar ruxsat tartibi READWRITE kalit so‘zi bilan belgilansa, unda himoyalanish darajasi READUNCOMMITTED bo‘lmasligi kerak.
3 Agar ruxsat tartibi va himoyalanish darajasi READUNCOMMITTED deb ko‘rsatilsa, unda beriladigan ruxsat tartibi READONLY deb tushuniladi, aks hollarda ruxsat tartibi READWRITE bo‘ladi. Ko‘pchilik hollarda tranzaksiyalaming bajarilish jarayonida MB jadvallari strkturasi buzilishining oldini olish uchun tranzaksiyalarga faqat o‘qish tartibini o‘natish mumkin. Buning uchun quyidagi operator ishlatiladi:
Bu operator tranzaksiya jarayoni boshlanishidan oldin ko‘rsatiladi.
Masalan,
buyurtmalami qabul qilgan sotuvchini aniqlamoqchisiz. Bu ikki so‘rovni bir- biridan farq qilishi uchun matn kiritish yo‘li bilan tashkillashtirishimiz mumkin:
SELECT a.snum, sname, onum, ‘Highest on’, odate FROM Salespeople a.
Orders b
WHERE a.snum = b.snum
AND b.amt = (SELECT MAX (amt)
|
| |
