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
-
Economics & Finance
Articles by Sharon Christine
Page 19 of 34
nStore data in format of XML string in SAP HANA system
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 type VARCHAR or NVARCHAR.Specifies a namespace declaration of type VARCHAR or NVARCHAR.DescriptionReturns the matching XML element. The return value is of type VARCHAR/NVARCHAR or CLOB/NCLOB depending on the type given for .If an XML element is empty (for example, ), then an empty result is returned. If an XML element ...
Read MoreHow can we create a MySQL view by using data from multiple tables?
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 | Name | Address | Subject | +------+---------+------------+------------+ | 101 | YashPal | Amritsar | History | | 105 | Gaurav | Chandigarh | Literature | | 125 | Raman | Shimla | Computers | | 130 | Ram ...
Read MoreHow to declare, create, initialize and access an array in Java?
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] = 102;You can access the array element using the index values −System.out.println("The first element of the array is: " + myArray [0]); System.out.println("The first element of the array is: " + myArray [1]); Alternatively, you can create and initialize an array using the flower braces ({ }): Int [] myArray = {10, 20, 30, 40, 50}
Read MoreIn MySQL, how can we get the number code of a particular character?
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 most character i.e. first character of the string given as argument.Examplemysql> Select ASCII('T'); +------------+ | ASCII('T') | +------------+ | 84 | +------------+ 1 row in set (0.01 sec) mysql> Select ASCII('t'); +------------+ | ASCII('t') | +------------+ | 116 | +------------+ 1 row ...
Read MoreHow can CONCAT_WS() function be used with MySQL WHERE clause?
When we use CONCAT_WS() function with WHERE clause then the output would be based upon the condition provided in WHERE clause. It can be understood from the example of ‘Student’ table as followsExamplemysql> Select CONCAT_WS(' ',Name, Last_name, 'Resident of', Address, 'is studying', Subject)AS 'Student Detail' from student WHERE id = 20; +----------------------------------------------------------------+ | Student Detail | +----------------------------------------------------------------+ | Gaurav Rathore Resident of Jaipur is studying Computers | +----------------------------------------------------------------+ 1 row in set (0.00 sec)
Read MoreHow can we use ASCII() function with MySQL WHERE clause?
While using the ASCII() function with WHERE clause, the output returns by it will depend upon the condition given in WHERE clause. For example, suppose we have a table named ‘Student’ and we want to get the number code, higher than 65, of the first characters of the names of the students. The query for this can be written as follows −mysql> Select * from student; +------+---------+---------+-----------+ | Id | Name | Address | Subject | +------+---------+---------+-----------+ | 1 | Gaurav | Delhi | Computers | | 2 | Aarav | Mumbai | ...
Read MoreHow to Install and Configure an NTP Client and Server on Linux?
This article will help to know how to configure an NTP (Network Time Protocol) server and client on RHEL/Cent OS Linux to manage the system clock with to help of an NTP server.NTP (Network Time Protocol)NPT is used to synchronize a computer’s machine’s time with another time source. In RHEL / CentOS Linux we can use NTP or OpenNTPD server, which provides client and server software for time synchronization.Installing NTP SoftwareThe NTP package have utilities and daemons that will synchronize the machine time to Coordinated Universal Time (UTC) via the NTP protocol. The NTP package has ntpdate (Which updates the ...
Read MoreHow to Increase the Size of a Linux LVM by Adding a New Disk?
This article helps us to add a new disk to LVM ( Logical Volume Manager), the very best advantage of LVM over normal disk partitions is its support for “dynamic partitions”; you can create and resize (expand or shrink) LVM volumes dynamically as we needed. There is no limit of the physical disk boundary in LVM logical volumes, so you can create a large LVM volume that spans across multiple smaller physical disks. This flexibility partitioning allows you to manage storage space more efficiently as disk usage change from time to time.If you want to add new disks to an ...
Read MoreHow to Host Files using GitHub?
Before GitHub existed, all the companies have managed the programming source code in private. It was first introduced as a collaborative platform for developers and now almost all of the storage space online is shared here for collective work. Irrespective of major or minor companies, you will find and can also access all their GitHub accounts and download as well. It can be otherwise termed as a dump store of human knowledge.A common misconception that prevails is that, it is a development tool that is used only for coding and compiling computer languages. But the fact is far from it. ...
Read MoreHow to Get Fare Estimates for Uber Taxi's on Twitter?
Uber is a private car hire service which is one of the most taxi popular provider which presently operates in more than 500 cities worldwide. Everyone who wishes to use uber Taxi service is usually interested to know about how much will be the cost if they hire Uber taxi from one point to another. That’s simple, all you require to do is, type the command as to send it to @WhatTheFare and the bot would help you know approximately how much would be the fare in a minute or less.What is the Advantage?The bot, @WhatTheFare not only ...
Read More