Sharon Christine has Published 337 Articles
Sharon Christine
676 Views
In older SAP HANA versions, no XML functions were provided. With HANA 2.0, these two functions are provided- XMLEXTRACT and XMLEXTRACTVALUE for extracting XML string in SAP HANA.Use of XMLEXTRACTXMLEXTRACT(, [, ])Syntax to use −Specifies an XML document of type CLOB, NCLOB, VARCHAR, or NVARCHAR.Specifies an XPath expression of ... Read More
Sharon Christine
2K+ Views
MySQL UNION operator can combine two or more result sets hence we can use UNION operator to create a view having data from multiple tables. To understand this concept we are using the base tables ‘Student_info’ and ‘Student_detail’ having the following data −mysql> Select * from Student_info; +------+---------+------------+------------+ | id ... Read More
Sharon Christine
373 Views
You can declare an array just like a variable −int myArray[];You can create an array just like an object using the new keyword −myArray = new int[5];You can initialize the array by assigning values to all the elements one by one using the index −myArray [0] = 101; myArray [1] ... Read More
Sharon Christine
2K+ Views
The println() terminates the current line by writing the line separator string. The print() method just prints the given content.ExampleLive Demopublic class Sample { public static void main(String args[]) { System.out.println("Hello"); System.out.println("how are you"); System.out.print("Hello"); System.out.print("how are ... Read More
Sharon Christine
4K+ Views
You can convert a double array to a string using the toString() method. To convert a double array to a string array, convert each element of it to string and populate the String array with them.ExampleLive Demoimport java.util.Arrays; public class DoubleArrayToString { public static void main(String args[]) { ... Read More
Sharon Christine
3K+ Views
To move an element from one position to other (swap) you need to –Create a temp variable and assign the value of the original position to it.Now, assign the value in the new position to original position.Finally, assign the value in the temp to the new position.ExampleLive Demoimport java.util.Arrays; public ... Read More
Sharon Christine
2K+ Views
Note that Image must be uploaded from system to MIME beforehand.Run Transaction SE78 → Upload (F5).You have to declare 2 variables in the interface - global data with types string and xstring, You need to change the data declaration as below −data: gv_bmp_watermark type xstring. constants: gc_url_watermark type string value ... Read More
Sharon Christine
418 Views
With the help of MySQL string function ASCII(), we can get the number code of a particular character. Its syntax is ASCII(str) where, str, the argument of ASCII() function, is the string whose ASCII value of the first character to be retrieved.It will return the number code the left the ... Read More
Sharon Christine
11K+ Views
This article will help you to create IPtables rules that you can directly use for your daily or routine needs, These examples will act as basic templates for you to work on iptables with these rules which suit your specific requirement.Deleting the IPtables or Existing RulesBefore you start building new ... Read More
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP