George John has Published 777 Articles

Why is it not recommended to use the mixture of quoted as well as unquoted values in MySQL IN() function’s list?

George John

George John

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

132 Views

Actually, MySQL has different comparison rules for quoted values such as strings and unquoted values such as numbers. On mixing the quoted and unquoted values in IN() function list may lead to the inconsistent result set. For example, we must not write the query with IN() function like below − ... Read More

Using “SPELL AMOUNT” function to convert amounts in ABAP

George John

George John

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

916 Views

You can use the standard function module “SPELL AMOUNT”. It will convert amounts to corresponding words. To display function module, use Transaction code: SE37 Click on Search icon and select Function module: “SPELL AMOUNT”

How many ways a String object can be created in java?

George John

George John

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

1K+ Views

You can create a String by − Step 1 − Assigning a string value wrapped in " " to a String type variable. String message = "Hello Welcome to Tutorialspoint"; Step 2 − Creating an object of the String class using the new keyword by passing the string ... Read More

How to find consonants in a given string using Java?

George John

George John

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

4K+ Views

One way to find the vowels in a given String is to compare every character in it using the charAt() method with the vowel letters. Example Live Demo public class FindingConsonants { public static void main(String args[]) { String str = new String("Hi Welcome to Tutorialspoint"); for(int i=0; i

How to create a string from a Java ArrayList?

George John

George John

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

14K+ Views

To convert the contents of an ArrayList to a String, create a StringBuffer object append the contents of the ArrayList to it, finally convert the StringBuffer object to String using the toString() method. Example import java.util.ArrayList; public class String_ArrayList { public static void main(String args[]) ... Read More

Edit an ABAP Program using Transaction SE93, SE80

George John

George John

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

1K+ Views

You need to go to SE93 and input your Transaction code. It will display program name behind your transaction code. You can edit the programs using SE80 and SE38.  Below shows Transaction code: SE93 Following shows Transaction Code SE80 to edit an ABAP program by opening ABAP Development workbench: ... Read More

Checking active process in SAP system and which code is running

George John

George John

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

4K+ Views

There are a couple of Transactions- SM66 and SM50 that can be used for your requirement. The transaction SM66 is used to see all the active processes on the current system. You can choose a particular process you want to monitor by clicking on “process” and then click the “debugging” ... Read More

Advertisements