As we know that the range of TIME field in MySQL is ‘-838:59:59’ to ‘838:59:59’. Now, if TIMEDIFF() function’s output surpasses this range then MySQL will return either ‘-838:59:59’ or ‘838:59:59’ depends upon the values of the argument. Example mysql> Select TIMEDIFF('2017-09-01 03:05:45', '2017-10-22 03:05:45')AS 'Out of Range TIME ... Read More

By using DISTINCT keyword along with column name as the argument of COUNT() function we can count the number of unique values in a column. The syntax is as follows − SELECT COUNT(DISTINCT Col_name) FROM table_name; Example Suppose we have the following table mysql> Select * from ... Read More

HashMap is non-syncronized and is not thread safe while HashTable is thread safe and is synchronized. HashMap allows one null key and values can be null whereas HashTable doesn't allow null key or value. HashMap is faster than HashTable. HashMap iterator is fail-safe where HashTable iterator is not fail-safe. ... Read More

As we know that, MySQL database server is having the user table in MySQL database which is used to store the user accounts so by using MySQL database we can create user accounts in MySQL database server. There must be two things while creating the new user account, one is ... Read More

To find an octal number character with JavaScript Regular Expression, use the following. Add the octal number here − \xxx You can try to run the following code to find an octal number character. It searches for octal number 123 i.e S − Example Live Demo ... Read More

volatile means two things − The value of the variable may change without any code of yours changing it. Therefore whenever the compiler reads the value of the variable, it may not assume that it is the same as the last time it was read, or that it is ... Read More

"On a mean, a developer spends a considerable quantity of your time doing mundane tasks compiling the code, packaging the binaries, deploying the binaries to the checkserver, testing the changes, " copying the code from one location to another. To automate and simplify these tasks we can use build tools ... Read More

Yes, this is feasible. You can create simple transformation for XML in ABAP. You can also use cl_proxy_xml_transform to transform data between XML and ABAP. Let us say that you have created ABAP proxy using T-Code: SPROXY or it is generated via WebService generation utility, you can use utility class ... Read More

This problem commonly occurs when you move development objects from Transportable enabled package to non-Transportable package. You can resolve this issue by following steps − You need to migrate legacy package using report RS_MIGRATE_PACKAGES. Check SAP Note:  https://launchpad.support.sap.com/#/notes/1711900Then legacy package' will be removed, but the package will be still ... Read More

You can either go for some tools like SAPlink in this case. SAPlink will let you export custom objects. In case if you want to package them, it is possible to use SAPlink, however, I doubt that it covers all types.Another way using basis is that you can configure to ... Read More