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 by vanithasree
Page 4 of 6
How to setup user access limitation on a timely basis in SAP HANA
Setting up user access limitation on a timely basis in SAP HANA is an uncommon but feasible scenario. This approach allows you to automatically activate and deactivate user permissions based on scheduled time intervals. Implementation Steps Follow these steps to implement time-based user access control − Create a stored procedure with the entire responsibility of activating/deactivating users or authorizing and de-authorizing user access Create a batch user with sufficient privileges to execute the above-created procedures Set up a scheduled job to run the procedures automatically using hdbsql ...
Read MoreNegation logic in SAP ABAP
You can use BOOLC to sort out your negation logic requirement. It should be like this − Varbool = BOOLC( NOT Logical_operation ) But be clear in your implementation, as ABAP does not have a true bool type. It does not store true or false in bool type rather it stores 'X' or '' (empty string) for true and false respectively. Example with BOOLC Here's a practical example showing negation logic using BOOLC − DATA: lv_number TYPE i VALUE 10, lv_result TYPE c LENGTH 1. ...
Read MoreWhat is the difference between /* */ and /** */ comments in Java?
Multiline comments (/* */) are used to comment multiple lines in the source code. Example public class CommentsExample { /* Following is the main method here, We create a variable named num. And, print its value * */ public static void main(String args[]) { //Declaring a variable named num int num = 1; ...
Read MoreHow do I write constants names in Java?
While writing the name of the constants it is suggested to write all the letters in upper case. If constant contains more than one word they should be separated by underscore (_). Example public class ConstantsTest { public static final int MIN_VALUE = 22; public static final int MAX_VALUE = 222; public static void main(String args[]) { System.out.println("Value of the constant MIN_VALUE: "+MIN_VALUE); System.out.println("Value of the constant MAX_VALUE: "+MAX_VALUE); } } Output Value of the constant MIN_VALUE: 22 Value of the constant MAX_VALUE: 222
Read MoreWhat is the difference between simple name, canonical name and class name in a Java class?
Canonical name of a Java class is the name of the class along with the package. For example, the canonical name of the class File is java.io.File. You can also get the canonical name of a particular class using Java method. The class named Class provides a method getCanonicalName(), this method returns canonical name of the current class. Example import java.lang.*; public class ClassDemo { public static void main(String[] args) { ClassDemo c = new ClassDemo(); Class cls = c.getClass(); ...
Read MoreHow can we enter numerical values as a BINARY number in MySQL statement?
Following are the two approaches with the help of which we can enter numeric values as a BINARY number −By prefix ‘B’In this approach we need to quote binary numbers within single quotes with a prefix of B. Then BINARY number string will be automatically converted into a numerical value based on the expression context.Examplemysql> Select B'1110'+0; +-----------+ | B'1110'+0 | +-----------+ | 14 | +-----------+ 1 row in set (0.00 sec)By prefix 0bIn this approach, we need to write BINARY numbers without any quotes with a prefix of 0b. Then BINARY number string will be automatically ...
Read MoreWhy in MySQL, we cannot use arithmetic operators like '=', '<' or '<>' with NULL?
The reason behind it is that we will not receive any meaningful results from the comparisons when we use NULL with the comparison operators like ‘=’, ‘ Select 10 = NULL, 10< NULL, 10NULL; +-----------+----------+----------+ | 10 = NULL | 10< NULL | 10NULL | +-----------+----------+----------+ | NULL | NULL | NULL | +-----------+----------+----------+ 1 row in set (0.07 sec)The above result set is not meaningful in any sense.
Read MoreWhat are the restrictions, in terms of a number of rows and columns, with MySQL query having no table list?
The restriction on MySQL query having a notable list is that it can return, as a result, exactly one row but that result can contain multiple columns.Examplemysql> Select 65/NULL,65+NULL,65*NULL,65-NULL,65%NULL; +------------+--------------+-------------+-------------+---------+ | 65/NULL | 65+NULL | 65*NULL | 65-NULL | 65%NULL | +------------+--------------+-------------+-------------+---------+ | NULL | NULL | NULL | NULL | NULL | +------------+--------------+-------------+-------------+---------+ 1 row in set (0.00 sec)In the above example, we can see that MySQL returns only one row with five columns, having the result of five expressions, as a result when we do not have any table list in the statement.
Read MoreWhat are the synonym statements of MySQL DESCRIBE?
Followings are the synonyms statements of MySQL DESCRIBE i.e. the statements with the help of which we can get the same kind of information/structure of the table as we get from DESCRIBE −EXPLAIN StatementEXPLAIN is the synonym of the DESCRIBE statement. Its syntax is also similar to the DESCRIBE statement. Consider the following example −mysql> Explain Employee; +-------+-------------+------+-----+---------+------------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+------------------+ | ID | int(11) | NO | PRI | NULL | auto_increment | | ...
Read MoreCreate a procedure to find out the factorial of a number?
It can be created with the help of the following query −mysql> Delimiter // mysql> CREATE PROCEDURE fact(IN x INT) -> BEGIN -> DECLARE result INT; -> DECLARE i INT; -> SET result = 1; -> SET i = 1; -> WHILE i SET result = result * i; -> SET i = i + 1; -> END WHILE; -> SELECT x AS ...
Read More