In this case, the output of ASCII() function depends on the condition that whether we are providing NULL as a string or we are providing simply NULL to it. Following example will demonstrate the difference −mysql> SELECT ASCII(null); +-------------+ | ASCII(null) | +-------------+ | NULL        | +-------------+ ... Read More

We can use keyword CHANGE to modify the column/s of an existing table. With CHANGE keyword we can change the name of the column and its definition both. Its syntax would be a bit different from the syntax of ALTER TABLE with MODIFY keyword.SyntaxAlter table table_name CHANGE old_columnname1 new_columnname1 datatype, ... Read More

The database is created only once but it is necessary to select it each time we begin a MySQLsession. It can be done with the help of USE db_name statement on MySQL command line tool.mysql> Use Query; Database changedIt shows that we are now using query database.We can also select ... Read More

To generate prime numbers in JavaScript, you can try to run the following codeExampleLive Demo           JavaScript Prime                        for (var limit = 1; limit

To create a link to send email, use tag, with href attribute. The mail to link is added inside the tag. To add a subject, you need to add ? and then include the subject. All this comes inside the tag.Just keep in mind to add the ... Read More

Note that all SAP ERP all modules run on SAP ABAP stack. SAP NetWeaver Application Server (ABAP Stack) is part of the SAP NetWeaver portfolio and represents the ABAP-based technical basis for many SAP products. It delivers technical frameworks, tools, repositories, and much more.If you are planning to use SAP ... Read More

If you using Universe as the source, In UDT this can be defined at Universe level. You can limit the size of result set in Universe Parameters -> ControlsIn Query panel, you have an option to set the limit on rows retrieved for each individual query. This setting is called ... Read More

JVM has a method area common across all the threads. It contains per-class elements like constant pool, fields, method local data, method code, constructor codes etc. which are used in class and initialization of objects/interfaces.This method area gets created during JVM start-up. It is generally part of Heap area. It ... Read More

To find weather a string is rotation of another, concat the first string to itself twice and find weatherExample Live Demopublic class Sample {    public static void main(String args[]){       String str1 = "gala";       String str2 = "alag";       String s3 = str1+str1; ... Read More

The intern() method of the String method returns a canonical representation for the string object. A pool of strings, initially empty, is maintained privately by the class String.For any two strings s and t, s.intern() == t.intern() is true if and only if s.equals(t) is true.All literal strings and string-valued constant expressions ... Read More