If we want to compare the data values of two columns then we need to provide the name of the columns as arguments of MySQL STRCMP() function. Suppose we have a table named ‘Marks’ which contains the name of the student and their secured marks in different subjects. Now, if ... Read More

For updating the values in one MySQL table by using the values from another MySQL table, we need to use sub-query as an expression in the SET clause of the UPDATE statement.ExampleIn this example, we have two table ‘student’ and ‘info’. We will update the value of column ‘grade’ of ... Read More

We can see the create table statement of an existing table by using SHOW CREATE TABLE query.SyntaxSHOW CREATE TABLE table_name;Examplemysql> Show create table employee\G *************************** 1. row *************************** Table: employee Create Table: CREATE TABLE `employee` (    `Id` int(11) DEFAULT NULL,    `Name` varchar(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ... Read More

Following example shows how to remove a character from a particular position from a string with the help of removeCharAt(string, position) method.ExampleLive Demopublic class Sample {    public static void main(String args[]) {       String str = "this is Java";       System.out.println(removeCharAt(str, 3));    }   ... Read More

To delete a setter using the delete operator, use the delete keyword. Here’s how you can delete −delete obj.nameExampleYou can try to run the following code to learn how to delete a setterLive Demo                    var department = {     ... Read More

Rest parametersWith rest parameter, you can represent a number of arguments as an array. ES6 brought rest parameter to ease the work of developers. For arguments objects, rest parameters are indicated by three dots … and precedes a parameter.Arguments objectArguments object in JavaScript is an object, which represents the arguments ... Read More

To get the first index of an occurrence of the specified value in a string, use the JavaScript indexOf() method.ExampleYou can try to run the following code to get the first index −Live Demo           JavaScript String indexOf() Method             ... Read More

To create a link, use the JavaScript link() method. This method creates an HTML hypertext link that requests another URL. The following is the syntax:string.link( hrefname )Above, hrefname is any string that specifies the HREF of the tag; it should be a valid URL.ExampleYou can try to run the ... Read More

JDK, contains development tools and JRE.

SAP List Viewer is used to add an ALV component and provides a flexible environment to display lists and tabular structure. A standard output consists of header, toolbar, and an output table. The user can adjust the settings to add column display, aggregations, and sorting options using additional dialog boxes.You ... Read More