- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Anvi Jain has Published 629 Articles
Anvi Jain
3K+ Views
In this program we will see how to exchange a block of 10-byte data using 8085.Problem StatementWrite 8085 Assembly language program to exchange a block of data, where block size is 10.DiscussionThe data are stored at location 8010H to 8019H and 9010H to 9019H. The location 8000H is holding the ... Read More
Anvi Jain
3K+ Views
Now let us see a program of Intel 8085 Microprocessor. This program will convert ASCII to binary values.Problem StatementWrite 8085 Assembly language program to convert ASCII to binary or Hexadecimal character values. DiscussionWe know that the ASCII of number 00H is 30H (48D), and ASCII of 09H is39H (57D). So all ... Read More
Anvi Jain
461 Views
Every DMA channel consists an address register and a count register. These registers are 16-bits wide in length. In each 16 bits there are four ARs marked as AR3-0. Apart from four CRs there are control and status registers also. They are separate 8-bit registers, but have the same address. Here ... Read More
Anvi Jain
3K+ Views
Now let us see a program of Intel 8085 Microprocessor. This program will convert ASCII to binary values.Problem StatementWrite 8085 Assembly language program to check whether a bit pattern is palindrome or not.DiscussionIn this program we are taking the number from location 8000H. The program will return 00H if the ... Read More
Anvi Jain
2K+ Views
Now let us see a program of Intel 8085 Microprocessor. This program will find the multiplication result of two BCD numbers.Problem StatementWrite 8085 Assembly language program to find two BCD number multiplication. The numbers are stored at location 8000H and 8001H.DiscussionIn this program the data are taken from 8000H and ... Read More
Anvi Jain
2K+ Views
The 8257 pins are described is given in the table below.Fig. Physical pin diagram of Intel 8257Fig: Functional pin diagram of Intel 82578257 is using a power of 5V.D7-0/A15-8For communicating with the processor there are 8 bidirectional data pins, when the processor is in active and the 8257 s active ... Read More
Anvi Jain
5K+ Views
You can group month and year with the help of function DATE_FORMAT() in MySQL. The GROUP BY clause is also used.The syntax is as follows −SELECT DATE_FORMAT(yourColumnName, '%m-%Y') from yourTableName GROUP BY MONTH(yourColumnName), YEAR(yourColumnName)DESC;To understand the above concept, let us create a table. The following is the query to create ... Read More
Anvi Jain
499 Views
To implement GROUP BY on two fields and count, let us create a table. The following is the query to create a table −mysql> create table GroupByTwoFieldsDemo −> ( −> Id int, −> Name varchar(200) −> ); Query OK, 0 rows affected (0.53 sec)Let us insert ... Read More
Anvi Jain
770 Views
In order to get all characters before space in MySQL, you can use left() function from the MySQL. The syntax is as follows −select left(yourColumnName, LOCATE(' ', yourColumnName) - 1) as anyVariableName from yourTableName;To understand the above concept, let us create a table.The query to create a table is as ... Read More
Anvi Jain
3K+ Views
To create a cumulative sum column in MySQL, you need to create a variable and set to value to 0. Cumulative sum increments the next value step by step with current value.Firstly, you need to create a variable with the help of SET. The syntax is as follows −set @anyVariableName:= ... Read More