Muhammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti 2 – bosqich dbm002-guruh talabasi Abdimannonov Jahongirning “Ma’lumotlar bazasi” fanidan bajargan 3- mustaqil ishi

LENGTH- Qator uzunligini qaytaradi (baytda).

LTRIM - qator boshidagi bo’sh joylar (probel)larni o’chiradi.

RTRIM -funksiyasi satr oxiridagi bo'sh joyni olib tashlash orqali asl nusxadan olingan satrni qaytaradi.

LEFT -funktsiyasi asl satrning boshlang'ich satrini qaytaradi

LEFT -funktsiyasi asl satrning boshlang'ich satrini qaytaradi

RIGHT- funktsiyasi belgilangan sondan tashkil topgan pastki qatorni qaytaradi.

Ishni bajarish tartibi

Korpus nomli jadvalga yuqorida ko`rsatilgan buyruqlarini tadbiq qiling.

1. So`rov: Select * from ticket;

Natija:

So`rov: Select LOWER(status) from ticket;

So`rov: Select LOWER(status) from ticket;

Natija:

So`rov: Select UPPER(status) from ticket;

So`rov: Select UPPER(status) from ticket;

Natija:

So`rov: Select LPAD(status,3,’may’) as newarea from ticket;

So`rov: Select LPAD(status,3,’may’) as newarea from ticket;

Natija:

So`rov:Select RPAD (status,3,’may’) as qisqartirma from ticket;

So`rov:Select RPAD (status,3,’may’) as qisqartirma from ticket;

Natija:

So`rov: select Length() from ticket;

So`rov: select Length() from ticket;

Natija:

So`rov: Select id, fullName, age, LTRM(nation), RTRM(nation) from passenger;

So`rov: Select id, fullName, age, LTRM(nation), RTRM(nation) from passenger;

Natija:

So`rov: Select Left(status,4) as status from ticket;

So`rov: Select Left(status,4) as status from ticket;

Natija:

So`rov: Select Right(status, 4) as korpus_nomi from korpus;

So`rov: Select Right(status, 4) as korpus_nomi from korpus;

Natija:

Qolganlari ishlamadi except ham