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
What happens if a NULL argument is provided in MySQL CONV() function?
MySQL will return NULL as the output if any of the argument of CONV() function is NULL or if the value provided for the base is out of limit(i.e. not between minimum 2 and maximum 36). Following examples would demonstrate it. Example mysql> Select CONV(10,NULL,2); +-----------------+ | CONV(10, NULL,2)| +-----------------+ | NULL | +-----------------+ 1 row in set (0.00 sec) mysql> Select CONV(10,10, NULL); +------------------+ | CONV(10,10, NULL)| +------------------+ | NULL | +------------------+ 1 row in set (0.00 sec) mysql> Select CONV(NULL,10,2); +-----------------+ | CONV(null,10,2) | +-----------------+ | NULL | +-----------------+ 1 row in set (0.00 sec)
Read MoreDifferentiating between row and column store table in SAP HANA database
Yes, it is possible to differentiate between both the table types. When you go to schema and view the newly created table, you can see vertical lines in front of table name and it confirms that this is column store table.In below pic, you can see the difference between a Row store table and Column store table.
Read MoreHow MySQL behaves if I use INTERVAL keyword with an invalid date?
Actually, the behavior of MySQL depends upon the allow_invalid_dates mode. If this mode is enabled then MySQL will accept the invalid date and it would perform the date arithmetic as it performs with a valid date. Otherwise, if this mode is inactive then it will not accept the invalid date and would produce NULL as output. mysql> select '2017-02-30' + INTERVAL 7 day; +-------------------------------+ | '2017-02-30' + INTERVAL 7 day | +-------------------------------+ | NULL ...
Read MoreHow to add a Favicon to Your WordPress Site?
A favicon is a little icon visible on the web browser tab, just before the page title. It is generally a logo with the smaller size. You need to include a Site Icon in WordPress to add a favicon to your WordPress site. Login to your WordPress website and from the left menu; click Appearance, and then Customize − After that, you will reach the Theme Customization section. Under that, the first sub-section is Site Identity. From there, you need to go to the Site Icon and upload the icon. The size here is 512x512, from which the ...
Read MoreConstructors of StringTokenizer class in Java.
Following are the important constructors of the StringTokenizer class.Sr.No.Constructor & Description1StringTokenizer(String str)This constructor a string tokenizer for the specified string.2StringTokenizer(String str, String delim)This constructor constructs string tokenizer for the specified string.3StringTokenizer(String str, String delim, boolean returnDelims)This constructor constructs a string tokenizer for the specified string.
Read MoreMaintaining password policy parameters in SAP HANA system
Note that actual parameter of password policy section is maintained by indexserver.ini system file. It is recommended that password policy should be configured using Security editor of SAP HANA Studio however this can also be done by editing indexserver.ini file.
Read MoreWhen are python objects candidates for garbage collection?
A python object or variable will be eligible for garbage collection as soon as all references to it go out of scope or are manually deleted (del x). We would have to presume there were no references to the object anywhere else for it to be garbage collected.
Read MoreChanges to indexserver.ini file auditable to maintain password policy in SAP HANA
It is recommended that password policy should be configured using Security editor of SAP HANA Studio however this can also be done by editing indexserver.ini file.Note that direct changes to the indexserver.ini file cannot be audited.
Read MoreWhy can't static method be abstract in Java?
A static method belongs to class not to object instance thus it cannot be overridden or implemented in a child class. So there is no use of making a static method as abstract.
Read MoreHow to convert List to int[] in Java?
You can simply iterate through list and fill the array as shown below −import java.util.ArrayList; import java.util.List; public class Tester { public static void main(String[] args) { List list = new ArrayList(); list.add(new Integer(1)); list.add(new Integer(2)); list.add(new Integer(3)); list.add(new Integer(4)); int[] array = new int[list.size()]; for(int i=0;i
Read More