Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
This can be achieved by using String Expressions or by using CONCATENATE keyword. With the use of “Concatenate” operator && you can do this.To use String Expressions, you should check online documentation and sample programs by using T-code: ABAPDOCU as shown above.You can also refer to below link for ABAP documentation:https://help.sap.com/doc/abapdocu_731_index_htm/7.31/en-US/index.htm
There are different ways that you can use to check the performance of your program. As per my understanding, you can join all tables like this:SELECT t11~orgeh t11~msty t11~mshort t12~position t13~job t14~job_grade t14~scheme INTO gt_my_combined_table FROM zgerpt_rnk_min as t11 JOIN hrp1001 as t12 ON t11~orgeh = t12~objid JOIN hrp1001 as t13 ON t12~position = t13~objid JOIN hrp9003 ON t13~job = t14~objid WHERE t12~otype = 'O' AND T12~sclas = 'S' AND T12~begda LE p_keydt AND T12~endda GE p_keydt AND T12~plvar ='01' AND T12~istat = '1' AND T12~objid ... Read More
SAP provides standard tables that you can use to get the detail about Transport objects.E070: Change & Transport System: Header of Requests/TasksE070T: Change & Transport System: Short Texts for Requests/TasksE071: Change & Transport System: Object Entries of Requests/Tasks (This table provides you details of transport objects).E070A: Change & Transport System: Attributes of a RequestE070C: CTS: Source/Target Client of Requests/TasksTo open any of the table, you can T-code: SE11 Enter table E071. You can group result in Grid Display by PGMID, OBJECT, and OBJ_NAME.
To count, you can use SUM() along with CASE statement for conditions. Let us first create a table −mysql> create table DemoTable1485 -> ( -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentName varchar(20), -> StudentSubject varchar(20) -> ); Query OK, 0 rows affected (0.72 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1485(StudentName, StudentSubject) values('Chris', 'MySQL'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1485(StudentName, StudentSubject) values('Robert', 'MongoDB'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable1485(StudentName, StudentSubject) values('Robert', 'MongoDB'); Query OK, 1 row affected ... Read More
To indicate whether the specified Unicode character is white space, the code is as follows −Example Live Demousing System; public class Demo { public static void Main() { bool res; char val = ' '; Console.WriteLine("Value = "+val); res = Char.IsWhiteSpace(val); Console.WriteLine("Is the value whitespace? = "+res); } }OutputThis will produce the following output −Value = Is the value whitespace? = TrueExampleLet us see another example − Live Demousing System; public class Demo { public static void Main() { bool res; ... Read More
Let us first create a table −mysql> create table DemoTable1484 -> ( -> Id int -> ); Query OK, 0 rows affected (0.46 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1484 values(100); Query OK, 1 row affected (0.25 sec) mysql> insert into DemoTable1484 values(175); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable1484 values(165); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable1484 values(145); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable1484 values(170); Query OK, 1 row affected (0.10 sec)Display all records from the table ... Read More
The StringCollection class represents a collection of strings. Following are the properties of the StringCollection class −Sr.noProperty & Description1CountGets the number of key/values pairs contained in the OrderedDictionary collection.2IsReadOnlyGets a value indicating whether the StringCollection is read-only..3IsSynchronizedGets a value indicating whether access to the StringCollection is synchronized (thread safe).4Item[Int32]Gets or sets the element at the specified index.5SyncRootGets an object that can be used to synchronize access to the StringCollection.Following are the methods of the StringCollection class −Sr.noMethod & Description1Add(String)Adds a string to the end of the StringCollection.2AddRange(String[])Copies the elements of a string array to the end of the StringCollection.3Clear()Removes all ... Read More
Let us first create a table −mysql> create table DemoTable1483 -> ( -> Salary int -> ); Query OK, 0 rows affected (0.41 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1483 values(100); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable1483 values(500); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1483 values(400); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select * from DemoTable1483;This will produce the following output −+--------+ | Salary | +--------+ | 100 | | ... Read More
For this, use \G as in the below syntax −select * from yourTableName\GLet us first create a table −mysql> create table DemoTable1482 -> ( -> Title varchar(255) -> ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1482 values('Deep Dive using Java with Data Structure And Algorithm'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1482 values('Introduction To MySQL and MongoDB'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select * from DemoTable1482;This will produce the following ... Read More
To find the capacity of a StringBuilder in C#, the code is as follows −Example Live Demousing System; using System.Text; public class Demo { public static void Main(String[] args) { StringBuilder strBuilder1 = new StringBuilder("Tim"); StringBuilder strBuilder2 = new StringBuilder("Tom"); StringBuilder strBuilder3 = new StringBuilder(); Console.WriteLine("Capacity of StringBuilder1 = "+strBuilder1.Capacity); Console.WriteLine("Capacity of StringBuilder2 = "+strBuilder2.Capacity); Console.WriteLine("Capacity of StringBuilder3 = "+strBuilder3.Capacity); strBuilder2 = strBuilder3; Console.WriteLine("Is StringBuilder3 equal to StringBuilder2? = "+strBuilder3.Equals(strBuilder2)); } }OutputThis will produce the ... Read More