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
Check if a large number is divisible by 11 or not in java
A number is divisible by 11 if the difference between the sum of its alternative digits is divisible by 11.i.e. if (sum of odd digits) – ( sum of even digits) is 0 or divisible by 11 then the given number is divisible by 11.Programimport java.util.Scanner; public class DivisibleBy11 { public static void main(String args[]) { Scanner sc = new Scanner(System.in); System.out.println("Enter a number :"); String num = sc.nextLine(); int digitSumEve = 0; int digitSumOdd = 0; for(int i = 0; i
Read MoreWhat are some amazing facts related to Facebook?
As of the first quarter of 2018, Facebook had 2.19 billion monthly active users. In the third quarter of 2012, the number of active Facebook users had surpassed one billion, making it the first social network ever to do so. Active users are those, which have logged in to Facebook during the last 30 days.The number of mobile Facebook users across the globe in 2018 is 1.34 Billion.Facebook's total quarterly revenue as of the first quarter of 2018 has amounted to 11.96 billion U.S. dollars, the majority of which were generated through advertising.24 Aug 2015, a billion people used Facebook ...
Read MoreHow does the 'off-the-record' chat option of Gmail work? Can these messages be retrieved?
One of the features in Google hangouts ensures that no record of your chat history is stored. To enable this, you simply have to go to −Hangouts> Open any conversation> Go to Setting> check for the option 'Conversation History'> Uncheck the box placed in front of this option>Checked: History is turned on.Unchecked: History is turned off.Now the answer to your another question on retrieving the messages is that 'You, as a user' cannot retrieve; however, your employer, in case you use a shared network, can not only see but retrieve even from 'off' mode. Although, I know that Gmail claims ...
Read MoreWhat is NDPS Act?
The Narcotic Drugs and Psychotropic Substances Act, 1985 is generally referred to as the NDPS Act, which prohibits any individual who is engaged in any activity consisting of producing, cultivating, selling, purchasing, transporting, storing, and/or consuming any narcotic drug or psychotropic substance.When Was It Introduced?The Narcotic Drugs and Psychotropic Substances bill was presented in the Lok Sabha on 23 August 1985 and later, passed by both Lok Sabha and Rajya Sabha. Later on, the then President Giani Zail Singh received this on 16 September 1985 and came into force on 14 Nov 1985.
Read MoreGCD and LCM of two numbers in Java
Following is an example which computes find LCM and GCD of two given numbers.Programimport java.util.Scanner; public class LCM_GCD { public static void lcm(int a, int b){ int max, step, lcm = 0; if(a > b){ max = step = a; } else{ max = step = b; } while(a!= 0) { if(max%a == 0 && max%b == 0) { lcm = max; break; } max += step; } System.out.println("LCM of given numbers is :: "+lcm); } public static void gcd(int a,int b){ int i, hcf = 0; for(i = 1; i
Read MorePrefix sum array in python using accumulate function
Given an array and we have to do the prefix sum array using accumulate function.itertools.accumulate(iterable[, func]) module functions all construct and return iterators. So they should only be accessed by functions or loops that truncate the stream. Make an iterator that returns accumulated sums. Elements may be any addable type including Decimal or Fraction. If the optional function argument is supplied, it should be a function of two arguments and it will be used instead of addition.ExampleInput Data = [1, 0, 2, 3, 5] >>> list(accumulate(data)) # running summation Output [1, 1, 3, 6, 11]AlgorithmStep 1: Create list. Step 2: ...
Read MoreWhen running UPDATE ... datetime = NOW(); will all rows updated have the same date/ time in mysql?
The now() function returns the constant time that exhibits the time at which any statement began to execute. The sysdate() function returns the exact same datetime at which it executed the statement from MySQL 5.0.13.Suppose if you are updating datetime with now() in triggers or stored procedure, the now() method returns the time at which time the triggering and stored procedure begin to execute.Here is the demo of update with now(). Let us first create a table. The query to create a table is as follows −mysql> create table NowDemo -> ( -> DueDateTime datetime -> ); Query OK, 0 ...
Read MoreHow to insert date in single quotes with MySQL date formats?
To insert the date with date formats, use the str_to_date() function with date in single quotes. The following is the syntax −insert into yourTableName values(Value1, value2, ......ValueN, str_to_date(‘anyDate’, ’%Y-%m-%d’));Here are the Date Formats in MySQL −FormatDescription%aAbbreviated weekday name (Sun to Sat)%bAbbreviated month name (Jan to Dec)%cNumeric month name (0 to 12)%DDay of the month as a numeric value, followed by suffix (1st, 2nd, 3rd, ...)%dDay of the month as a numeric value (01 to 31)%eDay of the month as a numeric value (0 to 31)%fMicroseconds (000000 to 999999)%HHour (00 to 23)%hHour (00 to 12)%IHour (00 to 12)%iMinutes (00 to 59)%jDay ...
Read MoreHow add unique key to existing table (with non-unique rows)?
You can add unique key to existing table with the help of alter command. The syntax is as follows −ALTER TABLE yourTableName ADD CONSTRAINT yourConstraintName UNIQUE(yourColumnName1, yourColumnName2, ............N);To understand the above concept, let us create a table with some columns. The query to create a table −mysql> create table MovieCollectionDemo −> ( −> MovieId int, −> MovieDirectorName varchar(200), −> NumberOfSongs int unsigned −> ); Query OK, 0 rows affected (0.62 sec)Now you can check the table does not have any unique constraint. The query to check unique constraint is ...
Read MoreGenerating a range of numbers in MySQL?
To generate a range of numbers in MySQL, you can use stored procedure. Firstly, we need to create a table. After that, we will create a stored procedure that generates a range of number from 10 to 1.The following is the query to create a table −mysql> create table GeneratingNumbersDemo −> ( −> Number int −> ); Query OK, 0 rows affected (0.55 sec)Now you can create a stored procedure that stores a range of numbers in the table. The following is the query to create a stored procedure −mysql> delimiter // mysql> CREATE PROCEDURE ...
Read More