Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
When working with SAP HANA queries that contain comparison operators like > (greater than) in XML contexts, you need to use CDATA sections. The term CDATA means Character Data. CDATA is defined as blocks of text that are not parsed by the XML parser, but are otherwise recognized as markup. The predefined XML entities such as , and & require entity encoding and are generally difficult to read in the markup. Instead of writing > for the greater than operator, CDATA sections allow you to use the actual > symbol directly. CDATA Section Syntax Following is the ... Read More
Note that attachEvent is no longer supported in IE11 and you should use addEventListener that can be used to bind specific function to an event. Using attachEvent in Older IE Versions In older versions of IE (IE8 and below), you can use attachEvent like this − object.attachEvent(event, pDisp) Parameters event [in] Type: String A String that specifies any of the standard DHTML Events. ... Read More
You can make the connection between ABAP Dynpro screen elements and program variables by using the name of Global variables. A Global variable can be defined by using this code − DATA matnr TYPE MATNR. This creates a global variable matnr of type MATNR. You can also define DDIC structure or table references using the TABLES statement − TABLES: MARA. Once you have declared the table or structure, you can reference the fields of table/structure ... Read More
To change the first and last elements of a list, you can use jQuery's eq() method along with first() and last() methods. The eq() method allows you to select elements by their index position, where the first element has an index of 0. Methods for Selecting First and Last Elements jQuery provides several methods to target the first and last elements − :first or first() − Selects the first element :last or last() − Selects the last element ... Read More
When working with internal tables in SAP ABAP, there are two main declaration approaches that differ in memory allocation and performance characteristics. Declaration Methods The two common ways to declare internal tables are − Method 1: With Initial Size DATA: itab TYPE TABLE OF customer_tab INITIAL SIZE 5. Method 2: Without Initial Size DATA: itab TYPE TABLE OF customer_tab. Key Differences As per my understanding, the key difference between two statements is that in first you are reserving memory space for storing 5 lines of the customer_tab table. ... Read More
To insert array lists into a HANA database, you can use JDBC statements with HANA's ARRAY function. This approach allows you to store multiple values as array columns in your database table. Example The following code demonstrates how to insert array data into a HANA database table − Integer[][] myarray = { {1}, {1, 2}, {1, 2, 3, 4, 5} }; String test = "Insert Arrays"; stopWatch.start(test); myDBconn.setAutoCommit(false); Statement stmt = myDBconn.createStatement(); stmt.execute("TRUNCATE TABLE Schema.Table1"); // Running a loop over our array of arrays for (int i = 0 ; i < (myarray.length); i++) { ... Read More
The RoundingMode function is used for rounding numbers in SAPUI5 and it uses these parameters: the number to be rounded and how many decimal digits to display. This is particularly useful when working with currency values or percentages that need to be displayed with consistent decimal places. Using Float Type with Format Options You can round a number to 2 decimal places by using the sap.ui.model.type.Float type with specific format options in your data binding − Format Options Explained The format options control how the number is displayed − ... Read More
To access element with nth index from an HTML page, use the jQuery eq() method. It is used to access the index of an element in jQuery. The eq() method refers to the position of the element. The eq() method accepts a zero-based index parameter, meaning the first element is at index 0, the second element is at index 1, and so on. This method returns a jQuery object containing only the element at the specified index position. Syntax The ... Read More
To access the index of an element in jQuery, use the eq() method. The eq() method refers to the position of the element and allows you to select a specific element from a matched set based on its zero-based index position. Syntax The basic syntax for the eq() method is − $(selector).eq(index) Where index is a zero-based integer indicating the position of the element you want to select. Example You can try to run the following code to learn how to access index of an element in jQuery − ... Read More
You can use regular expressions to remove duplicate consecutive alphanumeric characters from column data in SQL. The REPLACE_REGEXPR function with pattern matching allows you to identify and replace repeated characters with a single occurrence. Syntax The basic syntax for removing duplicate alphanumeric entries using regular expressions is − REPLACE_REGEXPR ('([A-Za-z0-9])\1+' in column_name WITH '\1' OCCURRENCE ALL) Where ([A-Za-z0-9])\1+ is the regex pattern that captures any alphanumeric character and matches one or more consecutive occurrences ... Read More