Other functions

SLEEP

SLEEP(sec)

This function pauses for the specified time then resumes the operations.

Parameters

sec – sleep time. The unit is second and inputs double type value.

Return type

INT

SELECT SLEEP(3);

It pauses for 3 seconds.

SYS_GUID

SYS_GUID()

It returns the unique hexadecimal string of 32 characters randomly.

SELECT SYS_GUID();
sys_guid()
==================================
'938210043A7B4455927A8697FB2571FF'