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
Program to convert two-digit hex to two ASCII values in 8085 Microprocessor
Here we will see a program of Intel 8085 Microprocessor. Using this program, we can convert 8-bit numbers to two digit ASCII values.Problem Statement− Write an 8085 Assembly language program to convert 8-bit binary to 2-character ASCII values. The 8-bit binary number is stored in memory location 8050H. Separate each nibbles and convert it to corresponding ASCII code and store it to the memory location 8060H and 8061H.Discussion−In this problem we are using a subroutine to convert one hexadecimal digit (nibble) to its equivalent ASCII values. As the 8-bit number contains two nibbles, so we can execute this subroutine to find ...
Read MoreProgram to convert ASCII to binary in 8085 Microprocessor
Here we will see one 8085 program, the program will convert ASCII to binary values.Problem Statement− Write an 8085 Assembly level program to convert ASCII to binary or Hexadecimal character equivalent values.Discussion−The ASCII of number 00H is 30H (48D), and ASCII of 09H is 39H (57D). So all other numbers are in the range 30H to 39H. The ASCII value of 0AH is 41H (65D) and ASCII of 0FH is 46H (70D), so all other alphabets (B, C, D, E, F) are in the range 41H to 46H.Here the logic is simple. We will check whether the ASCII value is less ...
Read MoreProgram to alternately display 00 and FF in the data field in 8085 Microprocessor
Here we will see one 8085 microprocessor program. This program will generate 00H and FFH alternatively.Problem Statement − Write an 8085 Assembly language program that can generate 00H and FFH alternatively.Discussion − The 00H and FFH are changed alternatively in each second. So we need one second delay. We have created delay subroutine to generate 1s delay.Note: Here for simplicity we are storing the numbers into memory. To show the numbers, we can use 7 – segment display and other display function for showing it into the display.InputHere we are not providing any input.Flow DiagramProgramAddressHEX CodesLabelsMnemonicsCommentsF000AFLOOPXRA AClear A registerF00132, 50, 80 STA 8050H Store 00H ...
Read MoreComparison of I/O port chips and memory chips in 8085
In this section we will see the basic comparisons between I/O port chips and the memory chips in 8085 microprocessor.Information is also stored in an Input Output port chip similar to a memory chip. Information of 1 byte are stored in an Input Output port chip on the other hand information of few bytes are stored in the Input Output port chips. An example to be cited as only 1 byte of information is stored in Intel 8212 I/O port chip, but 3 bytes of information are stored in Intel 8255 chip. Moreover, a large number of memory locations like ...
Read MoreWhat is a Computer language?
To communicate with the computers, we need some languages. These are computer languages.There are mainly three different languages with the help of which we can develop computer programs. And they are –Machine Level languageAssembly Level Language andHigh Level LanguageMachine Level LanguageComputer can understand only the language of Digital Electronics. Digital Electronics deals with presence and absence of voltages. Within the computer there are two logics can play their role. These logics are –Positive Logic – Here presence of voltage will be denoted by 1 and absence of voltage will be denoted by 0Negative Logic – Here presence of voltage will be ...
Read MoreMySQL query for grouping and summing the values based on specific records
Use GROUP BY to group records, whereas SUM() function is used to add. Let us first create a table −mysql> create table DemoTable ( Name varchar(40), Subject varchar(40), Marks int ); Query OK, 0 rows affected (2.89 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris', 'MySQL', 76); Query OK, 1 row affected (0.32 sec) mysql> insert into DemoTable values('Sam', 'MongoDB', 86); Query OK, 1 row affected (0.39 sec) mysql> insert into DemoTable values('Mike', 'MySQL', 98); Query OK, 1 row affected (0.46 sec) mysql> insert into DemoTable values('David', 'Java', 93); Query OK, ...
Read MoreUpdate the table by calculating the sum and display the result as last column value
Use a variable to store SUM(total) and update it with the UPDATE command. Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Value int ); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Value) values(70); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable(Value) values(100); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable(Value) values(150); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable(Value) values(250); Query OK, 1 row affected (0.14 sec) mysql> ...
Read MoreHow can I return a record from a table nearest to a user-defined variables value in MySQL?
Let us first create a table −mysql> create table DemoTable ( CustomerId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ProductAmount int ); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(ProductAmount) values(5000); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable(ProductAmount) values(6000); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable(ProductAmount) values(7000); Query OK, 1 row affected (0.26 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+------------+---------------+ | CustomerId | ProductAmount | +------------+---------------+ | ...
Read MoreHow does COALESCE order results with NULL and NON-NULL values?
The COALESCE() finds the NON-NULL value first If it finds the same in the beginning, then it returns, otherwise moves ahead to check NON-NULL value.Let us first create a table −mysql> create table DemoTable ( Number1 int, Number2 int ); Query OK, 0 rows affected (5.48 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 200); Query OK, 1 row affected (0.40 sec) mysql> insert into DemoTable values(NULL, 50); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(10, NULL); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable ...
Read MoreMySQL query to find latest 3 dates in a table and the resultant dates shouldn't be duplicate
To find the latest dates, order the date records with ORDER BY DESC. Since we want only 3 dates, use LIMIT 3.Let us first create a table −mysql> create table DemoTable ( AdmissionDate date ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-09-04'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('2019-08-10'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('2019-09-21'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('2019-09-18'); Query OK, 1 row affected (0.17 sec) mysql> ...
Read More