MAKE_SET(bits,str1,str2,…)
SQL> SELECT MAKE_SET(1,'a','b','c');
+---------------------------------------------------
------+
| MAKE_SET(1,'a','b','c')
|
+---------------------------------------------------
------+
| a
|
+---------------------------------------------------
------+
1 row in set (0.00 sec)
MID(str,pos,len)
MID(str,pos,len) sinonimi SUBSTRING(str,pos,len).
OCT(N)
SQL> SELECT OCT(12);
+---------------------------------------------------
------+
| OCT(12)
|
+---------------------------------------------------
------+
| 14
|
+---------------------------------------------------
------+
1 row in set (0.00 sec)
Topshiriq: Har bir talaba o’ziga berilgan predmet soha mavzusi
bo’yicha standart operatoridan foydalanib so’rovlar yaratishi va
natijasi bilan ko’rsatib o’tishi kerak.