ELT(N, str1, str2, str3, …)
SQL> SELECT ELT(1, 'ej', 'Heja', 'hej', 'foo');
+---------------------------------------------------
------+
| ELT(1, 'ej', 'Heja', 'hej', 'foo')
|
+---------------------------------------------------
------+
| ej
|
+---------------------------------------------------
------+
1 row in set (0.00 sec)
EXPORT_SET(bits,on,off[,separator[,number_of_bits]])
SQL> SELECT EXPORT_SET(5,'Y','N',',',4);
+---------------------------------------------------
------+
| EXPORT_SET(5,'Y','N',',',4)
|
+---------------------------------------------------
------+
| Y,N,Y,N
|
+---------------------------------------------------
------+
1 row in set (0.00 sec)
Do'stlaringiz bilan baham: |