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
Which one is better in MySQL - NULL or empty string?
The choice depends upon the database. In ORACLE database, an empty string is converted to NULL.In MySQL, the usage of an empty string is better as compared to NULL. It is easy to check for an empty string with some boundary conditions, while this cannot be done with NULL. To find NULL, we need to add an extra condition i.e. ‘IS NULL’We can check that the length of NULL is 0 while length of empty string is 1.To check the length of NULL.mysql>SELECT count(NULL);The following is the output of the above query.+-----------------+ | count(NULL) | +-----------------+ ...
Read MoreHow will drones help improve the security?
Proper security involves all-around surveillance or observation of people, their behavior and actions, immovable property like land and building as well as movable property stationed there. Surveillance is generally conducted with the help of methods that either have limited mobility or are stationary like, CCTV cameras, GPS tracking dependent on satellite connectivity and not helpful in close observation, stake-outs, which are time-consuming, data-based profiling and biometrics and some other methods.Drone Has Turned the TableAll these methods have their own level of advantages and limitations but when it comes to drone technology, the efficiency, and effectiveness of any security operation increase ...
Read MoreWhat is the career prospect in drone technology?
Jobs in drone technology-driven enterprises are the jobs of the future because drones are going to play a very crucial role across a large number of industries in future. Many youngsters think that jobs in the drone domain involve just engineering and technological openings but the fact is there are many other openings which don't require you to be a technological wizard.Drone PilotingThis is one specialization that is already opening up many opportunities for youngsters. Drones are finding application in different sectors like mining, security services including private security for industrial and commercial assets, disaster management, logistics and many others. ...
Read MoreHow to get locale information from Network provider in android?
This example demonstrate about How to get locale information from Network provider 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 text view to show locale infomation.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.Manifest; import android.content.pm.PackageManager; import android.location.Address; import android.location.Geocoder; import android.location.Location; import android.location.LocationManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v4.app.ActivityCompat; import android.support.v7.app.AppCompatActivity; import android.widget.TextView; import java.io.IOException; ...
Read MoreWhat is meant by recycling unicorns?
In the world of business, Unicorns are by no means the mythical single horned Equus; it refers to the category of companies called startups with a valuation of over a billion dollars. Hence, recycling unicorns are nothing but startups in the recycling sector that are worth over a billion dollars. It was venture capitalist Aileen Lee who first coined the term 'unicorn' for startups that broke the billion-dollar threshold and the reason he did so was that startups that are worth a billion dollars are as elusive as the mythical unicorn. And yet, there are over 200 unicorns around the ...
Read MoreWhy are the keys on the keyboard not arranged in alphabetical order?
The arrangement of keys in a typing keypad that we have today is nearly a century and half old. Initially, in the olden days the typewriter machines did have the keys arranged alphabetically but because the machines were too slow in comparison to the speed at which users learned to master them, it presented a different problem.Swift UsersThe users turned out to be way faster than the machines and this resulted in the mechanical character arms getting jumbled up all over. Therefore, the makers of typewriters in response to customer experience and feedback designed a completely new keyboard where the ...
Read More8085 Program to Add two multi-byte BCD numbers
Now let us see a program of Intel 8085 Microprocessor. This program is mainly for adding multi-digit BCD (Binary Coded Decimal) numbers.Problem StatementWrite 8085 Assembly language program to add two multi-byte BCD (Binary Coded Decimal) numbers. DiscussionWe are using 4-byte BCD numbers. The numbers are stored into the memory at location 8501H and8505H. One additional information is stored at location 8500H. In this place, we are storing the byte count. The result is stored at location 85F0H.The HL pair is storing the address of first operand bytes, the DE is storing the address of second operand bytes. C is holding the ...
Read More8085 Program to Add N numbers, of size 8 bits
In this program, we will see how to add a block of data using the 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to add N 1-byte numbers. The value of N is provided.DiscussionIn this problem, we are using location 8000H to hold the length of the block. The main block is stored from address 8010H. We are storing the result at location 9000H and 9001H. The 9000H holding the lower byte, and 9001H is holding the upper byte.Repeatedly we are taking the number from the memory, then adding it with the accumulator and increase the register E content when carry ...
Read MoreWhat is the role of local community media in strengthening democracy at the grassroot level?
There can be no doubt about the critical role that community media can play in strengthening democracy at the grass-root level. For most folks in urban areas, especially in Tier I, II and even III cities this issue might not generate much interest, but for those in the smaller towns and villages, this is one issue that will spark immediate interest. That's because folks living in such areas that are classified as rural, don't take a lot of things for granted like their counterparts in cities do.Keep An Insight of the Local PoliticsMost of us in cities don't even know ...
Read MoreRegister codes of 8085 Microprocessor
Using 16-bit address, 8085 can access one of the 216= 64K locations. As a single hexadecimal digit can be expressed in4-bit notation so, in 8085, memory address can be expressed using four hexadecimal digits. Similarly, for convenience, we can represent all 8085 CPU registers as A, B, C etc. using binary notations. Internally 8085 specifies these registers using 0s and 1s only. So3-bits are just enough to represent a register. The 3-bit register codes for the registers of 8085 are shown in the following tableWith 3-bit register code, eight registers can be specified in maximum as 23= 8. On the ...
Read More