Swarali Sree has Published 75 Articles

How to check statement of creating a particular MySQL database?

Swarali Sree

Swarali Sree

Updated on 28-Jan-2020 10:38:25

76 Views

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

When are two tables connected with MySQL FOREIGN KEY then how can we say that the integrity of data is maintained in child table?

Swarali Sree

Swarali Sree

Updated on 28-Jan-2020 07:12:54

125 Views

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

How to use nested while loop in JavaScript?

Swarali Sree

Swarali Sree

Updated on 08-Jan-2020 09:15:17

1K+ Views

The purpose of a while loop is to execute a statement or code block repeatedly as long as an expression is true. Once the expression becomes false, the loop terminates.ExampleYou can try to run the following code to learn how to use nested while loopLive Demo         ... Read More

What is a ternary operator (?:) in JavaScript?

Swarali Sree

Swarali Sree

Updated on 07-Jan-2020 10:58:35

441 Views

The conditional operator or ternary operator first evaluates an expression for a true or false value and then executes one of the two given statements depending upon the result of the evaluation.S.NoOperator & Description1? : (Conditional )If Condition is true? Then value X: Otherwise value YExampleYou can try to run ... Read More

How to use arrow functions used as methods in JavaScript?

Swarali Sree

Swarali Sree

Updated on 07-Jan-2020 08:03:40

135 Views

Fat arrow function as the name suggests helps in decreasing line of code. The syntax => shows fat arrow. This also avoids you to write the keyword “function” repeatedly. Arrow functions are generally used for a non-method function. Let’s see how to use arrow functions used as methods:ExampleYou can try ... Read More

Print screen using VBA in SAP

Swarali Sree

Swarali Sree

Updated on 16-Dec-2019 07:51:47

590 Views

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

Differentiate between Transaction code SE01, SE09, and SE10 in SAP ECC system?

Swarali Sree

Swarali Sree

Updated on 11-Dec-2019 10:35:21

517 Views

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

Difference between SE01, SE09 and SE10 Transactions in SAP

Swarali Sree

Swarali Sree

Updated on 11-Dec-2019 10:25:17

2K+ Views

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

Using logarithm in SAP ABAP

Swarali Sree

Swarali Sree

Updated on 10-Dec-2019 07:46:01

441 Views

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

How to convert/store a string of numbers in to an array in java?

Swarali Sree

Swarali Sree

Updated on 30-Jul-2019 22:30:21

2K+ Views

You can convert a String to an integer using the parseInt() method of the Integer class. To convert a string array to an integer array, convert each element of it to integer and populate the integer array with them.Example Live Demoimport java.util.Arrays; public class StringToIntegerArray {    public static void ... Read More

Advertisements