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
8085 program with a subroutine to add ten packed BCD numbers.
Here we will see how to add ten packed BCD numbers using 8085.Problem StatementA set of ten packed BCD numbers is stored in the memory location starting from 8040H to 8049H.Write a program with a subroutine to add these numbers in BCD. If a carry is generated save it to register B, and adjust it to BCD. The final sum will be less than 9999BCD. Store the sum at locations 8060H and 8061H.Write a second subroutine to unpack the BCD sum stored in registers A and B, and store them in the OutputBuffer memory starting at 8062H. The most significant ...
Read MoreGROUP BY and display only non-empty column values in MySQL
Let us first create a table −mysql> create table DemoTable -> ( -> Id varchar(100), -> Message varchar(200) -> ); Query OK, 0 rows affected (1.17 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('1', ''); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values('1', 'Hi'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable values('2', 'Hello'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('3', 'Awesome'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('3', ...
Read MoreHow to show Alert Dialog in iOS?
Knowing how to play with Alert is very important if you’re designing any iOS Application. Here we will be focusing on how to show Alert using UIAlertController.To read more about UIAlertController refer − https://developer.apple.com/documentation/uikit/uialertcontrollerIn this, we will be creating a new project where we will have a button, on tapping that button we will show alert with custom message.Step 1 − Open Xcode → New Projecr → Single View Application → Let’s name it “Alert”Step 2 − Open Main.storyboard and add a button and name it tap. Create @IBAction of that button in ViewController.swit and name the same as tap.There’s ...
Read MoreWhere and how to use static variable in swift?
Before we see where and how to use static variable, let us first understand, What is static variable in swift?Static VariableStatic variables are those variables whose values are shared among all the instance or object of a class. When we define any variable as static, it gets attached to a class rather than an object. The memory for the static variable will be allocation during the class loading time.Let us understand above figure, we have a class Sample and it has two object s1 and s2. You see s1 and s2 both have their variable “a” separately but they have ...
Read MoreOrder By date ASC in MySQL?
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 into DemoTable values('14-12-2016'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('26-04-2018'); Query OK, 1 row affected (0.34 sec) mysql> insert into DemoTable values('31-05-2013'); Query OK, 1 row affected (0.30 sec)Display all records from the table using select statement −mysql> select * from DemoTable;This will produce the ...
Read MoreJava DatabaseMetaData getMaxTablesInSelect() method with example.
The getMaxTablesInSelect() method of the DatabaseMetaData interface is used to find out the maximum number of tables that the underlying database allows in an SQL SELECT statement.This method returns an integer value, representing the maximum number of tables allowed in a SELECT statement. If this value is 0 it indicates that there is no limit or, limit is unknown.To get the DatabaseMetaData object −Make sure your database is up and running.Register the driver using the registerDriver() method of the DriverManager class. Pass an object of the driver class corresponding to the underlying database.Get the connection object using the getConnection() method ...
Read MoreFetch data between two rows in MySQL?
To fetch data between two rows, use the concept of LIMIT. Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(10) ); Query OK, 0 rows affected (0.22 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Name) values('Larry'); Query OK, 1 row affected (0.06 sec) mysql> insert into DemoTable(Name) values('Robert'); Query OK, 1 row affected (0.05 sec) mysql> insert into DemoTable(Name) values('Chris'); Query OK, 1 row affected (0.05 sec) mysql> insert into DemoTable(Name) values('David'); Query OK, 1 row affected ...
Read MoreHow to disable only the horizontal scrollbar in Java?
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 scrollbar −Examplepackage my; import java.awt.BorderLayout; import java.awt.Dimension; import javax.swing.Box; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JScrollPane; public class SwingDemo { public static void main(String args[]) { JFrame frame = new JFrame("Demo"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); JButton button1 = new JButton("Tutorials"); JButton ...
Read MoreGetting the maximum value from a varchar field in MySQL
Use MAX() function along with SUBSTRING() for this. Let us first create a table −mysql> create table DemoTable -> ( -> Id varchar(200) -> ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-0515-1980'); Query OK, 1 row affected (0.49 sec) mysql> insert into DemoTable values('2019-0516-780'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values('2019-0517-2780'); Query OK, 1 row affected (0.16 sec)Display all records from the table using select statement −mysql> select *from DemoTable;Output+----------------+ | Id ...
Read MoreHow to detect a long press in iOS?
Long-press (also known as press-and-hold) gestures detect one or more fingers touching the screen for an extended period of time. You configure the minimum duration required to recognize the press and the number of times the fingers must be touching the screen. (The gesture recognizer is triggered only by the duration of the touches and not by the force associated with them.) You might use a long-press gesture to initiate an action on the object being pressed. For example, you might use it to display a context-sensitive menu.You can read more about it https://developer.apple.com/documentation/uikit/touches_presses_and_gestures/handling_uikit_gestures/handling_long-press_gesturesHere we will be designing a simple ...
Read More