George John has Published 1167 Articles

Remove new line characters from rows in MySQL?

George John

George John

Updated on 26-Jun-2020 12:48:38

4K+ Views

The Trim() function is used to remove new line characters from data rows in MySQL. Let us see an example. First, we will create a table. The CREATE command is used to create a table.mysql> create table tblDemotrail - > ( - > id int, - > name varchar(100) - ... Read More

8085 Program to Add two multi-byte BCD numbers

George John

George John

Updated on 26-Jun-2020 12:14:21

945 Views

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 ... Read More

Immediate addressing mode in 8085 Microprocessor

George John

George John

Updated on 26-Jun-2020 11:55:19

1K+ Views

In this mode, the 8/16-bit data is specified in the instruction itself as one of its operand. For example MVI E, ABH: means ABH is copied into register A. Here the operand is immediately available in the instruction.MVI E ABHBeforeAfter(A)Any valueABHAs example, if we consider instruction MVI E, ABH then ... Read More

In-service register in 8259

George John

George John

Updated on 26-Jun-2020 10:57:54

572 Views

Also, an 8-bit register which keeps track records of the interrupt requests that are currently being executed. If the request IR6 is currently being served, whose contents of ISR will be 01000000. If by any means the request to IR3 becomes active during the service process of IR6, 8259 sets ... Read More

8085 Program to convert HEX to ASCII

George John

George John

Updated on 26-Jun-2020 10:53:12

5K+ Views

Now let us see a program of Intel 8085 Microprocessor. This program will convert HEX to ASCII values.Problem StatementWrite 8085 Assembly language programs to convert Hexadecimal characters to ASCII values.DiscussionWe know that the ASCII of number 00H is 30H (48D), and ASCII of 09H is39H (57D). So all other numbers ... Read More

8085 Program to Multiply two 8 bits numbers

George John

George John

Updated on 26-Jun-2020 10:42:57

893 Views

In this program, we will see how to multiply two 8-bit numbers using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to multiply two 8-bit numbers stored in a memory location and store the 16-bit results into the memory.DiscussionThe 8085 has no multiplication operation. To get the result of multiplication, we ... Read More

Get the maximum of two numbers using Math.max in Java

George John

George John

Updated on 26-Jun-2020 10:03:08

1K+ Views

To obtain the maximum of two numbers using Math.max in Java, we use the java.lang.Math.max() method. The Math.max() accepts two numbers and returns the greater of the two. The result is closer to positive infinity on the number line. Even if one of the values is not a number(NaN), the ... Read More

Round float and double numbers in Java

George John

George John

Updated on 26-Jun-2020 10:00:20

8K+ Views

In order to round float and double numbers in Java, we use the java.lang.Math.round() method. The method accepts either double or float values and returns an integer value. It returns the closest integer to number. This is computed by adding ½ to the number and then flooring it.Declaration - The ... Read More

Check if the String contains only unicode letters or digits in Java

George John

George John

Updated on 26-Jun-2020 09:56:58

6K+ Views

To check whether a String contains only unicode letters or digits in Java, we use the isLetterOrDigit() method and charAt() method with decision-making statements.The isLetterOrDigit(char ch) method determines whether the specific character (Unicode ch) is either a letter or a digit. It returns a boolean value, either true or false.Declaration ... Read More

Get the arc tangent of a given value in Java

George John

George John

Updated on 26-Jun-2020 09:51:29

110 Views

To get the arc tangent of a given value in Java, we use the java.lang.Math.atan() method. The atan() method accepts a double value whose angle needs to be computed. The range of the angle returned lies in the range -pi/2 to pi/2. If the argument is NaN, then the result ... Read More

Advertisements