Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
You can perform varchar casting using following query:SELECT TO_ALPHANUM(col) FROM ......
Note that column number is used to locate table cell data and column name is unique identifier.object.GetCellData( row, column)- takes argument as long integers row and cell numbers to locate cell data.Try using GetCellData like this:Browser("Browser").Page("Page").Frame ("searchDialog").SAPTable("ResultsTable").GetCellData(1, 1) Browser("Browser").Page("Page").Frame ("searchDialog").SAPTable("ResultsTable").GetCellData(1, 2)
Note that IN statement in SQL doesn’t accept a wild character. You have to use OR/AND to make it work as mentioned below:select * from Test1 t INNER JOIN Test2 s ON t.ID = s.RID where t.sdate >= ?1 AND t.edate
You need to login to XM interface and there is different BAPI’s that you can use to read CCMS data.Function Module:BAPI_SYSTEM_ALERT_ACKNOWLEDGE BAPI_SYSTEM_ALERT_GETDETAILS BAPI_SYSTEM_MON_GETLIST BAPI_SYSTEM_MON_GETTEMPLATE BAPI_SYSTEM_MON_GETTREE You can refer this documentation to know more about Function Modules:https://archive.sap.com/kmuuid2/da4
In order to handle the assertion error, we need to declare the assertion statement in the try block and catch the assertion error in the catch block.Let us see a program on how to handle Assertion Error in Java −Examplepublic class Example { public static void main(String[] args) throws Exception { try { assert args.length > 0; } catch (AssertionError e) { System.out.println(e.getMessage()); } } }Output
In order to catch the assertion error, we need to declare the assertion statement in the try block with the second expression being the message to be displayed and catch the assertion error in the catch block.Let us see a program on how to handle Assertion Error in Java −Examplepublic class Example { public static void main(String[] args) throws Exception { try { assert args.length > 0 : "Assertion error caught!!!!"; } catch (AssertionError e) { System.out.println(e.getMessage()); } } }Output
The contamination of water bodies like lakes, rivers, ground water or oceans is termed water pollution. The main cause of this pollution is the discharge of harmful substances into water bodies without being treated. Water is the basic and most important element of life. Hence we must protect it from pollution.Water pollution is caused by many factors. Human or animal wastes, Chemicals released from factories, pesticides and other chemicals used in agriculture, oil spills, wastage from factories directed to water tanks etc., Water pollution has become a serious global problem as will cause many diseases and even deaths.We can control ... Read More
In order to match the city and state using regular expression, we use the matches method in Java. The java.lang.String.matches() method returns a boolean value which depends on the matching of the String with the regular expression.Declaration − The java.lang.String.matches() method is declared as follows −Example Live Demopublic class Example { public static void main( String[] args ) { System.out.println(city("Mumbai")); System.out.println(state("Goa")); } // validating the city public static boolean city( String c ) { return c.matches( "([a - zA - Z] + |[a - zA - Z] + ... Read More
To format message with floating point fillers in Java, we use the MessageFormat class. The MessageFormat class gives us a way to produce concatenated messages which are not dependent on the language. The MessageFormat class extends the Serializable and Cloneable interfaces.Declaration −The java.text.MessageFormat class is declared as follows −public class MessageFormat extends FormatThe MessageFormat.format(pattern, params) method formats the message and fills in the missing parts using the objects in the params array matching up the argument numbers and the array indices.The format method has two arguments, a pattern and an array of arguments. The pattern contains placeholder in {} curly ... Read More
To format message with currency fillers in Java, we use the MessageFormat class. The MessageFormat class gives us a way to produce concatenated messages which are not dependent on the language. The MessageFormat class extends the Serializable and Cloneable interfaces.Declaration −The java.text.MessageFormat class is declared as follows −public class MessageFormat extends FormatThe MessageFormat.format(pattern, params) method formats the message and fills in the missing parts using the objects in the params array matching up the argument numbers and the array indices.The format method has two arguments, a pattern and an array of arguments. The pattern contains placeholder in {} curly braces ... Read More