Tutorial by Examples: all

UNION ALL to select all (duplicate values also) cities from the "Customers" and "Suppliers" tables. Query: SELECT City FROM Customers UNION ALL SELECT City FROM Suppliers ORDER BY City; Result: Number of Records: 12 City ------- Aachen Albuquerque Anchorage Ann A...

UNION ALL to select all(duplicate values also) German cities from the "Customers" and "Suppliers" tables. Here Country="Germany" is to be specified in the where clause. Query: SELECT City, Country FROM Customers WHERE Country='Germany' UNION ALL SELECT City, Count...

Detailed instructions on getting text set up or installed.

As already pointed out in other pitfalls, catching all exceptions by using try { // Some code } catch (Exception) { // Some error handling } Comes with a lot of different problems. But one perticular problem is that it can lead to deadlocks as it breaks the interrupt system when writ...

The latest version of the Oracle Java style guide mandates that the "then" and "else" statements in an if statement should always be enclosed in "braces" or "curly brackets". Similar rules apply to the bodies of various loop statements. if (a) { //...

Following are the Prerequisites for installing Cookiecutter: pip virtualenv PostgreSQL Create a virtualenv for your project and activate it: $ mkvirtualenv <virtualenv name> $ workon <virtualenv name> Now install Cookiecutter using: $ pip install cookiecutter Change dire...

For more complex applications, flat execution profiles may be difficult to follow. This is why many profiling tools also generate some form of annotated callgraph information. gperf2dot converts text output from many profilers (Linux perf, callgrind, oprofile etc.) into a callgraph diagram. You can...

Hosted XSLT 2.0 Setup To run XSLT 2.0 in the browser, use one of the following XSLT 2.0 as a service hosts: XSLT Fiddle W3C XSLT Servlet Online XSLT Test Tool

TestNG requires JDK 7 or higher to use. According to http://testng.org/doc/download.html in order to install testng you need to add testng dependency to your maven pom.xml or gradle build.gradle file Maven: <repositories> <repository> <id>jcenter</id> <name...

echo off cls sqlcmd.exe -S "your server name" -U "sql user name" -P "sql password" -d "name of databse" -Q "here you may write your query/stored procedure" Batch files like these can be used to automate tasks, for example to make backups of ...

Detailed instructions on getting aspectj set up or installed.

cts:search( fn:doc(), cts:word-query("marklogic"))

This can be done in the following two ways - cts:search( fn:collection("first-collection"), cts:word-query("marklogic")) In this, the scope is changed from all the documents to documents in collection "first-collection" only. In the second approach, use ...

This query returns all the documents with element "company" and its value as "marklogic" cts:element-value-query(xs:QName('company'), 'marklogic'))

The methods object.wait(), object.notify() and object.notifyAll() are meant to be used in a very specific way. (see http://stackoverflow.com/documentation/java/5409/wait-notify#t=20160811161648303307 ) The "Lost Notification" problem One common beginner mistake is to unconditionally cal...

Detailed instructions on getting instagram set up or installed.

In order to get the official I18N Plugin into your CLI Project we need to install it by following the next steps. First you want to install the plugin via npm: npm install aurelia-i18n Since Aurelia-I18N is backed by i18next, you should install it and a backend plugin of your choice. As an exampl...

The simplest way is to use brew: brew install zsh After installation, you may want to set it as your default shell by doing: sudo echo '/usr/local/bin/zsh' >> /etc/shells chsh -s /usr/local/bin/zsh If you have git, and required command line tools installed you can compile and install ...

Detailed instructions on getting linux-device-driver set up or installed.

The display of elements in a list or grids is a very common pattern in mobile applications. The user sees a collection of items and can scroll through them. The collection of items can be a list, a grid or another structured representations of data. The RecyclerView widget is a more advanced and fl...