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 Giri Raju
Page 5 of 7
Sort data in SQL using Dynamic SQL in SAP HANA
In order to execute dynamic SQL in your stored procedure, you need to use the EXECUTE IMMEDIATE statement. This statement allows you to build and execute SQL queries dynamically at runtime, which is particularly useful when you need to sort data based on variables or user input. Basic Dynamic SQL Syntax You can use SQL as shown below to execute dynamic sorting − EXECUTE IMMEDIATE 'SELECT FROM ORDER BY ' || : || ' DESC'; Complete Example Here's a complete example showing how to implement dynamic sorting in a SAP HANA ...
Read MoreHandling higher level Boolean values in SAP system
As per the general standards and coding practice, you should use abap_bool for handling Boolean values or truth values in SAP systems. When any object is declared as abap_bool type, it can hold values only from the set (abap_true, abap_false, and abap_undefined). However, in older systems, you might not be able to use abap_bool as it is not available. For example, in Web Dynpro ABAP, abap_bool is not available. You need to use WDY_BOOLEAN as an alternative in this case. WDY_BOOLEAN only allows true Boolean values, meaning it allows only ...
Read MoreCan you extend a static inner class in Java?
A static inner class is a nested class which is a static member of the outer class. It can be accessed without instantiating the outer class, using other static members. Just like static members, a static nested class does not have access to the instance variables and methods of the outer class. You can extend static inner class with another inner class. Example public class SampleClass { static abstract class Test{ int num = 300; public abstract void display(); } ...
Read MoreWhat is method hiding in Java and how to use it?
When super class and sub class contains same method including parameters and if they are static. The method in the super class will be hidden by the one that is in the sub class. This mechanism is known as method hiding. Example class Demo{ public static void demoMethod() { System.out.println("method of super class"); } } public class Sample extends Demo { public static void demoMethod() { System.out.println("method of sub class"); } public static void main(String args[] ) { Sample.demoMethod(); } } Output method of sub class
Read MoreIntegrating .NET application with SAP system and using best practices
To connect a .NET application with SAP system, there are different approaches that you can follow:Use of SAP PI middleware that offers different protocols and communication framework for integration of two systems. SAP PI/XI enables you to set up cross system communication and integration and allows you to connect SAP and non-SAP systems based on different programming language like Java and SAP ABAP. It provides an open source environment that is necessary in complex system landscape for the integration of systems and for communication.SAP Process Integration is a middleware to allow seamless integration between SAP and non-SAP application in a ...
Read MoreHow can I check the tables of databases other than current database?
With the help of following MySQL command, we can check the tables of a database other than the database we are currently using −Show Tables from Database_name;For example, the following query would display the list of tables from a database named ‘gaurav’ when currently we are using a database named ‘new’ −mysql> use new; Database changed mysql> show tables from gaurav; +--------------------+ | Tables_in_tutorial | +--------------------+ | testing | | employee | | tender | | Ratelist | +--------------------+ 4 rows in set (0.00 sec)
Read MoreWhat happens if I use both G and semicolon (;) termination symbol with a single MySQL statement?
As we know that \G option sends the command to MySQL server for execution and with the help of Semicolon (;) MySQL determines the end of the statement. It is also known that both of them have a different format of the result set.Now, if we will use both of those in MySQL statement then the output would be produced on the basis that which of them is encountered first by MySQL. For others, MySQL will produce an error. It can be understood with the help of the following example −mysql> Select CURDATE();\G +------------+ | CURDATE() | +------------+ | 2017-11-06 ...
Read MoreHow the MySQL command that you are in the process of entering can be canceled?
Suppose if we do not want to execute a command that we are entering, then we can use a clear \c option which clears the current input. For example, the use of \c option can be done as follows −mysql> Select * -> from\cIn the example above, when we use \c in a statement, MySQL clears the current input and returns back to the MySQL prompt for accepting other statements.
Read MoreWhat is the maximum length of data we can put in a BLOB column in MySQL?
As we know that BLOB is a binary large object that can hold a variable amount of data. The different TEXT objects offer a range of storage space from 255 bytes to 4 Gb. Following table shows the storage of different kinds of BLOB data type −Type of BLOBMaximum amount of Data that can be storedOverhead TINYBLOBUp to 255 bytes1 byteBLOBUp to 64 Kb2 bytes MEDIUMBLOBUp to 16 Mb3 bytes LONGBLOBUp to 4 Gb1 Bytes
Read MoreWhat kind of compound units can be used in MySQL EXTRACT() function?
MySQL EXTRACT() function can use following compound units −SECOND_MICROSECONDMINUTE_MICROSECONDHOUR_MICROSECONDDAY_MICROSECONDMINUTE_SECONDHOUR_SECONDHOUR_MINUTEDAY_SECONDDAY_MINUTEDAY_HOURYEAR_MONTHSome of the examples of these compound units used in EXTRACT() function are as follows −mysql> Select EXTRACT(YEAR_MONTH from '2017-10-20'); +---------------------------------------+ | EXTRACT(YEAR_MONTH from '2017-10-20') | +---------------------------------------+ | 201710 | +---------------------------------------+ 1 row in set (0.00 sec)Above query will return the year and month value from the date.mysql> Select EXTRACT(DAY_HOUR from '2017-10-20 05:46:45'); +----------------------------------------------+ | EXTRACT(DAY_HOUR from '2017-10-20 05:46:45') | +----------------------------------------------+ | ...
Read More