In this program we will see how to reverse a 16-bit number using 8-bit operation.Problem StatementWrite 8086 Assembly language program to reverse a 16-bit number which is stored at location 2000 and 2001, using 8-bit operations.Discussion8086 has 8-bit operation for rotation. For 16-bit number, we are taking the bytes from ... Read More

Here we will see how to find the bit differences of two binary patterns using 8085.Problem StatementTwo binary patterns are stored in locations 8030H and 8031H. Load them in registers A and B. Find out the bit positions where bits are differing and put these location numbers at locations starting ... Read More

You can use STR_TO_DATE() function. Let us first create a table −mysql> create table DemoTable    (    AdmissionDate varchar(200)    ); Query OK, 0 rows affected (1.19 sec)Insert records in the table using insert command −mysql> insert into DemoTable values('12-01-2019'); Query OK, 1 row affected (0.14 sec) mysql> insert ... Read More

To disable only the horizontal scrollbar in Java, use the JScrollPane.HORIZONTAL_SCROLLBAR_NEVER. Let’s say you created a Box with some button components. Now, create a JScrollPane −JScrollPane scrollPane = new JScrollPane();Set the Viewport view as Box −scrollPane.setViewportView(box);Now, disable the horizontal scrollbar −scrollPane.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_NEVER);The following is an example to disable only the horizontal ... Read More

You can use a CASE statement for this. Let us first create a table −mysql> create table DemoTable    (    Number int    ); Query OK, 0 rows affected (0.71 sec)Insert records in the table using insert command −mysql> insert into DemoTable values(490); Query OK, 1 row affected (0.35 ... Read More

Here we will see how to interface PORT IC with 8085.Problem StatementON/OFF desired output LEDs connected at the output port B.DiscussionHere we will see how to On/Off LEDs at port B. We are using 8255 IC for ports. The J1 and J2 connectors to connect the 8085 and 8255. The ... Read More

You can use aggregate function MAX() and MIN() for this.Let us first create a table −mysql> create table DemoTable    (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Number1 int,    Number2 int    ); Query OK, 0 rows affected (0.89 sec)Insert records in the table using insert ... Read More

Here we will see we can take 16-bit BCD data from memory and unpack it, then store into memory using 8085.Problem StatementWrite 8085 program to take 16-bit BCD number from memory then store each digit by unpacking into different locations.DiscussionTo solve this problem, we will create one subroutine, that can ... Read More

You can use substring() for fields in MySQL to get part of string. Following is the syntax −select substring(yourColumnName, yourStartingIndex, yourEndingIndex) from yourTableName;Let us first create a table −mysql> create table DemoTable    (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Title longtext    ); Query OK, 0 ... Read More

Here we will see how we can take all numbers whose D7 and D1 bits are 0, using 8085.Problem StatementWrite 8085 program to take all numbers from an array whose D7 and D1 bits are 0. Numbers are stored from 8001, and the array size is stored at 8000. Store ... Read More