MySQL CASE statement is a flow control function that allows us to build conditions inside a query such as SELECT or WHERE clause. We have two syntaxes of CASE statementSyntax-1CASE val WHEN compare_val1 THEN result1 WHEN compare_val2 THEN result2 . . . Else result ENDHere in this 1st syntax, if ... Read More

MySQL INSERT() function performs no insertion if the position of insertion is out of range. The position of insertion can be out of range in the case when we pass a negative or 0(zero) value or the value goes beyond the value of a total number of characters in an ... Read More

With the help of CREATE DATABASE db-name command, we can check the statement of creating any MySQL database.mysql> SHOW CREATE DATABASE Sample; +----------+-------------------------------------------------------------------+ | Database | Create Database                                             ... Read More

Actually, foreign keys enforce referential integrity that helps us to maintain the consistency and integrity of the data automatically. It can be understood with the example of two tables named ‘customer’ and ‘orders’. Here, ‘customer’ is the parent table and ‘orders’ is the child table. We cannot create an order ... Read More

If you are using SendKeys then avoid using it. I had used it in the past project and it seems to be inconsistent and error-prone.You can use the below snippet at the top of the module and call it wherever required.Option Explicit Private Declare Sub keybd_event Lib "user32" (ByVal bVk ... Read More

In early sap version, SE09 and SE10 perform different functions as below:SE09 was widely used in workbench/development of transports.SE10 was widely used in customizing transports.In newer version now, both the Transactions SE09 and SE10 perform the same function as shown in below snapshot.In addition, SE01 is an extension combining SE09 ... Read More

Both SE09 and SE10 were used in earlier releases of SAP for different purposes.SE09 – This was used for development of transportsSE10 – This was used for customizing the transports request. When you run SE10 in SAP ERP, you will get the same screen as in T-Code SE09 of Transport ... Read More

Yes, there is a log function. You can use it to implement your requirement.Here is a code snippet which might be of some help for your implementation.DATA:  NUMBER  TYPE INT,        BASE TYPE INT,        RESULT  TYPE FLOATLet’s say:Number=16 BASE=4 RESULT= log(NUMBER)/log(BASE)RESULT will be 2.Read More

A Java file contains only one public class with a particular name. If you create another class with same name it will be a duplicate class. Still if you try to create such class then the compiler will generate a compile time error. Example public class Example { } ... Read More

A checked exception is an exception that occurs at the time of compilation, these are also called as compile time exceptions. These exceptions cannot simply be ignored at the time of compilation; the programmer should take care of (handle) these exceptions. if you use FileReader class in your program to ... Read More