CONCAT_WS(separator,str1,str2,…)
SQL> SELECT CONCAT_WS(',','First name','Last Name'
);
+---------------------------------------------------
------+
| CONCAT_WS(',','First name','Last Name' )
|
+---------------------------------------------------
------+
| First name,Last Name
|
+---------------------------------------------------
------+
1 row in set (0.00 sec)
CONV(N, N from_base, to_base)
SQL> SELECT CONV('a',16,2);
+---------------------------------------------------
------+
| CONV('a',16,2)
|
+---------------------------------------------------
------+
| 1010
|
+---------------------------------------------------
------+
1 row in set (0.00 sec)
Do'stlaringiz bilan baham: |