How to insert the mobile number on an android application using EditText

Number Insertion in android application: Sometimes while dealing with numbers, we don’t want to insert any string inside an number so, we premiliary define an EditText so we externally specify an EditText attribute as android:inputType=”number”  After specifying this attribute in the EditText, it will be used only to insert a number. Step 1: Create a …

Read moreHow to insert the mobile number on an android application using EditText

How to insert an email in android application in android version 8

Email Address Insertion It is used to insert email adrress from the user in the android application.The only point of difference between an EditText and an Emailtext is that EmailText consisits of attribute named as android:inputType=”textEmailAddress”. Email address consists of a local part followed by ‘@’ and then a case sensitive domain name. In this …

Read moreHow to insert an email in android application in android version 8

SQL TRUNCATE

This command deletes all records from table. Truncate is a DDL command. Syntax: TRUNCATE table table_name; Example: Truncate table teacher; ORDER BY The ORDER BY clause arranges the table or column in ascending or descending orders. By default, it is ascending order. ‘ASC’ used to indicate ascending order and ‘DESC’ used to indicate descending order.  …

Read moreSQL TRUNCATE

Categories sql

SQL Operators

Arithmetic Operators Arithmetic operators are +, -, *, /, % performs addition, subtraction, multiplication, division, modulo respectively. Example:   Select 100+222; Select salary+100 From teacher Where teacher_id=1; Following output screen shows different arithmetic operations. We can perform single operation at a time or multiple operations. Comparison Operators Comparison operators ‘<’,   ‘<=’, ‘>’, >, =’, =’ …

Read moreSQL Operators

Categories sql

SQL Scalar Functions

TEACHER Table LCASE() Function The LCASE() function is used to return lower case values of specified column. Syntax: Select Lcase(column_name) from table_name; Example: Select Lcase(teacher_name) from teacher; Syntax: Select Lcase(column_name) from table_name [where condition]; Example: Select Lcase(teacher_name) from teacher where teacher_id=1; UCASE() Function The UCASE() function is used to return values in upper case of …

Read moreSQL Scalar Functions

Categories sql

SQL Aggregate Functions

Max() Function The Max() function returns the maximum value of specified column. Syntax: Select Max(column_name) From table_name; Example: Select Max(salary) From teacher; Min() Function The Min() function returns the minimum value of specified column. Syntax: Select Min(column_name) From table_name; Example: Select Min(salary) From teacher; Sum() Function The Sum() function is used to perform addition on …

Read moreSQL Aggregate Functions

Categories sql

SQL CONSTRAINTS

SQL Constraints specifies the rules/limitations/restrictions for data present in table. SQL Constraints are specified at the time of table creation or after table creation using ALTER command. There are two types of constraints column-level constraint and table-level constraint. As the name column level specifies, it specifies a particular column. In a table level constraint, it …

Read moreSQL CONSTRAINTS

Categories sql