The electromagnetic spectrum is the entire range of electromagnetic radiation according to the wavelength or frequencies. It has a range of frequencies from 1Hz to Hz. The waves in order of increasing frequencies are radio waves, microwaves, infrared rays, visible light, UV rays, X-rays and gamma rays.Among these range, ... Read More

The EXISTS tells if the query returned results or not while IN can be used for comparing one value with other. IN uses literal values. Note − IN is preferred in a subquery whenever a subquery result is very small. If the subquery result is very large then EXISTS is ... Read More

Before getting into example we should know what is action bar in android. Action bar just like header in android. Either we can use same action bar for all screen or we can change action bar for particular activity.This example demonstrate about how to create a custom action bar in ... Read More

The strcoll() function is used to compare two strings based on locale. Note − This function is case-sensitive Syntax strcoll(str1, str2) Parameters str1 − First string to compare str2 − Second string to compare Return The strcoll() function returns − 0 − ... Read More

Before getting into Glide example, we should know what is glide, Glide is an image processing library developed by muyangmin. Using glide library we can show image, decode images, cache images, animated gifs and many more.This example demonstrate about how to integrate glide in android.Step 1 − Create a new ... Read More

The strnatcasecmp() function is used compare two strings with a natural algorithm. Note − The function is case sensitive. Syntax strnatcasecmp(str1, str2) Parameters str1 − First string to compare str2 − Second string to compare Return The strcoll() function returns − 0 ... Read More

Before getting into alert dialog, we should know about what is alert dialog, Alert dialog is just like a pop-up where user can choose action by clicking "ok" or "cancel" button.Methods in Alert DialogsetView(View view) − It used to set custom view to alert dialogsetTitle(CharSequence title) − It is used ... Read More

The strripos() function is used find the position of the last occurrence of a string inside the another string. Note − The function is case-insensitive. Syntax striipos(str, find, begin) Parameters str − The string to search. Required. find − The string to find. Required. begin ... Read More

The substr_count() function is used to count the number of sub-strings. Syntax substr_count(str, substr, begin, len) Parameters str − The string to check substr − The string to search for begin − Where to begin searching in the string len − The length ... Read More

To get table names using SELECT statement, use “information_schema.tables”. Let us see an example, wherein we have a database that contains 3 tables. The syntax to get all table names with the help of SELECT statement. SELECT Table_name as TablesName from information_schema.tables where table_schema = 'yourDatabaseName'; Using database ... Read More