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 on Trending Technologies
Technical articles with clear explanations and examples
What is The Prelude all about?
The Prelude is a long poem by William Wordsworth compiled into fourteen books. All these books trace his spiritual growth with the subtitle of the poem itself as its the theme, which is the growth of the poet's mind.Justification of the TitleThe title stands justified as Wordsworth describes how Nature began its mysterious work in his conscious and subconscious mind. He is convinced that there are hidden forces in Nature impacting him inadvertently right from the time he was a young boy and he thus, recounts a few incidents and comments upon their significance in shaping up his mind. The ...
Read MoreInsert the results of a MySQL select? Is it possible?
You do not need to use values whenever you insert the results of a select. To insert the results of select, let us first create two tables.The first table query is as follows −< FirstTableDemo> mysql> create table FirstTableDemo −> ( −> StudentId int, −> StudentName varchar(100) −> ); Query OK, 0 rows affected (0.41 sec)Now create second table and after that insert the second table records in the first table using INSERT SELECT command.The query to create the second table − mysql> create table SecondTableDemo −> ( −> Id int, −> ...
Read MoreHow to Show and hide a View with a slide up/down animation in android?
This example demonstrate about how to Show and hide a View with a slide up/down animation in android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. In the above code, we have taken button to show /hide linear layout with animation.Step 3 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.view.animation.TranslateAnimation; import ...
Read MoreEquaivalent of Oracle concatenation operator in MySQL?
The concat operator can be used in ORACLE. MySQL use concat() function to perform concatenation.To understand the concat() function, let us create a table. The query to create a table is as follows −mysql> create table ConcatenationDemo −> ( −> Id int, −> Name varchar(100) −> ); Query OK, 0 rows affected (0.86 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into ConcatenationDemo values(100, 'John'); Query OK, 1 row affected (0.19 sec) mysql> insert into ConcatenationDemo values(101, 'Sam'); Query ...
Read MoreHow do I use tabHost for Android?
Before getting into example we should know what is tab host in android. Tab host holds set of tabs. Each tab contains either fragment or activity as per project specification. The user can scroll tabs from left to right or right to left.This example demonstrates how to use tab host in android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. ...
Read MoreHow do I begin auto increment from a specific point in MySQL?
To begin auto increment from a specific point, use ALTER command. The syntax is as follows −ALTER TABLE yourTableName auto_increment = anySpecificPoint;To understand the above concept, let us create a table. The query to create a table is as follows −mysql> create table AutoIncrementSpecificPoint −> ( −> BookId int auto_increment not null, −> Primary key(BookId) −> ); Query OK, 0 rows affected (0.56 sec)Now you can insert records using insert command.The query is as follows −mysql> insert into AutoIncrementSpecificPoint values(); Query OK, 1 row affected (0.17 sec) ...
Read MoreWhat are some of the applications of LASER?
LASER is an acronym for Light Amplification by Stimulated Emission of Radiation. The LASER action was first proposed by Einstein.Applications of a LASERA LASER can be used in many fields. Some of its usages are given here.Used In Welding and Melting: The laser beam welding is mainly used for joining components using high welding speeds and low thermal distortion.Used In Holography: The reason that a hologram cannot be made without a LASER source is that coherence length for laser source can be very high due to which sustained interference pattern will be recorded on a hologram. This suggests the indispensable ...
Read MoreHow to make Android character by character display text animation?
This example demonstrate about How to make Android character by character display text animation.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.os.Bundle; import android.support.v7.app.AppCompatActivity; public class MainActivity extends AppCompatActivity { @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); Typewriter writer = new Typewriter(this); setContentView(writer); writer.setCharacterDelay(150); writer.animateText("Sample String...Sample String...Sample String..."); } }In the above code, ...
Read MoreWhy zero (0) is the first number?
Zero (0) is used as a number and also as the numerical digit. Zero gives the additive identity of the integers, real numbers, and many algebraic structures. It is used as a placeholder for writing numbers.Natural numbers start from 1, then 2 and so on. We cannot count backward with them. Integers, on the other hand, allows us to count backward. Zero winds up being a good choice for the number that should come after 1 as we count backward. Integers can go in both directions, to a positive infinity and also in the reverse direction to a negative infinity. ...
Read MoreGet timestamp date range with MySQL Select?
To select timestamp data range, use the below syntax −SELECT *FROM yourTableName where yourDataTimeField >= anyDateRange and yourDataTimeField < anyDateRangeTo understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table DateRange −> ( −> DueTime timestamp −> ); Query OK, 0 rows affected (1.34 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into DateRange values('2016-11-13'); Query OK, 1 row affected (0.51 sec) mysql> insert into DateRange values('2016-10-14'); Query OK, 1 row ...
Read More