Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by George John
Page 79 of 79
How MySQL SUM() function evaluates if the column having NULL values too?
Suppose if we are calculating the sum of the values of a column which also have NULL values then MySQL SUM() function ignores the NULL values and does the sum of the rest of the values. To understand it, consider the following example of table ‘employee’, having following details − mysql> Select * from Employee; +----+--------+--------+ | ID | Name | Salary | +----+--------+--------+ | 1 | Gaurav | 50000 | | 2 | Rahul | 20000 | | 3 | Advik | 25000 | | 4 | ...
Read MoreWhy is it not recommended to use the mixture of quoted as well as unquoted values in MySQL IN() function’s list?
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 − Select Salary from employee where ID IN(1,’a’,2,3,’c’) Instead of this the better way to write the above query is as follows − Select Salary from employee where ID IN(‘1’,’a’,’2’,’3’,’c’)
Read MoreUsing “SPELL AMOUNT” function to convert amounts in ABAP
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”
Read MoreHow many ways a String object can be created in java?
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 value as a parameter of its constructor. String message = new String ("Hello Welcome to Tutorialspoint"); Step 3 − Passing a character array to the String constructor. char arr[] = {'H','e','l','l','o'}; String message = new String(arr);
Read MoreHow to create a string from a Java ArrayList?
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[]) { ArrayList al = new ArrayList(); al.add("Hello"); al.add("are"); al.add("you"); StringBuffer sb = new StringBuffer(); for (String s : al) { sb.append(s); sb.append(" "); } String str = sb.toString(); System.out.println(str); } } Output Hello are you
Read MoreEdit an ABAP Program using Transaction SE93, SE80
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: Following shows Transaction Code SE38 to edit an ABAP program by opening ABAP Editor Initial screen and to enter the name of Program −
Read MoreChecking active process in SAP system and which code is running
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” button. The Transaction SM50 shows only the process running on a current application server in which you are logged. To monitor your program, select “Administration”, then “program” and then debugging option. You would require finding out the process in which your program is running. This can be done by ...
Read More