Vrundesha Joshi has Published 289 Articles

8085 program to find larger of two 8 bit numbers

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

4K+ Views

In this program we will see how to find the larger of two numbers.Problem StatementWrite 8085 Assembly language program to find the larger number of two 8-bit number store dat location 8000H and 8001H.DiscussionThis checking is done by using the CMP instruction. This instruction is very similar to the SUB ... Read More

How can I select the row with the highest ID in MySQL?

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

503 Views

You can select the row with highest ID in MySQL with the help of ORDER BY with LIMIT OFFSETThe syntax is as follows −select *from yourTableName order by yourColumnName desc limit 1 offset 0;To understand the above syntax, let us create a table. The query to create a table is ... Read More

8085 program to swap two 8 bit numbers using Direct addressing mode

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

692 Views

In this program we will see how to swap two numbers in direct addressing mode.Problem StatementWrite 8085 Assembly language program to swap two 8-bit number stored at location 8000H and 8001H using direct addressing mode. DiscussionIn this case we are taking the number from memory by using the HL pair. The ... Read More

8085 program to subtract two 8-bit numbers with or without borrow

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

2K+ Views

In this program we will see how to subtract two 8-bit numbers using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to subtract two 8-bit numbers with or without borrow and store the result at locations 8050H and 8051H.DiscussionIn 8085, the SUB instruction is used 2’s complemented method for subtraction. When ... Read More

What is the SQL command to return the field names of a table?

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

171 Views

To return the field names of a table, you can use desc command. The syntax is as follows −desc yourTableName;Or you can use column_name field from information_schema.columns table. The syntax is as follows −select column_name from information_schema.columns where table_name = ’yourTableName’;To understand both the syntax, let’s say we have a ... Read More

Non-Programmable 8-Bit I/O Port

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

701 Views

There are two types of Input Output ports. They are Programmable Input Output ports and Non-Programmable Input Output ports. Since the functions of Programmable Input Output ports changed by software they became more popular. We don't need to change the wiring rather the hardware of the I/O port to change ... Read More

Retrieve first 40 characters of a text field in MySQL?

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

168 Views

To get the first 40 characters from a text field, use LEFT() function from MySQL. The syntax is as follows −SELECT LEFT(yourColumnName, 40) as anyVariableName from yourTableName;To understand the above concept, let us create a table. The query to create a table is as follows −mysql> create table retrieveFirst40Characters ... Read More

8085 program to add numbers in an array

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

3K+ Views

In this program we will see how to add a blocks of data using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to add numbers in an array, where the size of the array is N. The value of N is provided.DiscussionIn this problem we are using location 8000H to hold ... Read More

8085 program to convert gray to binary

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

1K+ Views

Now let us see a program of Intel 8085 Microprocessor. This program will convert gray code to binary code.Problem StatementWrite an assembly language program for 8085 to convert gray code to binary code. The data is stored at address 8200H & store the result at memory location 8201H.DiscussionHere we are ... Read More

How to convert ArrayList to String using GSON?

Vrundesha Joshi

Vrundesha Joshi

Updated on 30-Jul-2019 22:30:24

2K+ Views

GSON is java library, It is used to convert OBJECT to JSON and JSON to Object. Internally it going to work based on serialization and de- serialization.This example demonstrate about how to convert ArrayList to string using GSON library.Step 1 − Create a new project in Android Studio, go to ... Read More

Advertisements