Tutorial by Examples: l

If the first parameter is NOT NULL, NVL2 will return the second parameter. Otherwise it will return the third one. SELECT NVL2(null, 'Foo', 'Bar'), NVL2(5, 'Foo', 'Bar') FROM DUAL; NVL2(NULL,'FOO','BAR')NVL2(5,'FOO','BAR')BarFoo

SELECT COALESCE(a, b, c, d, 5) FROM (SELECT NULL A, NULL b, NULL c, 4 d FROM DUAL); COALESCE(A,B,C,D,5)4 In some case, using COALESCE with two parameters can be faster than using NVL when the second parameter is not a constant. NVL will always evaluate both parameters. COALESCE will stop a...

A function that extends the functionality of the array by creating an object oriented remove function. // Need to restrict the extension to elements that can be compared. // The `Element` is the generics name defined by Array for its item types. // This restriction also gives us access to `index(...

There are some spawning rules in Worlds in Bukkit. They are: Animal Spawning Creature Spawning Amount of the above that can be spawned Animal Spawning Animal spawning can be split into the following categories: Water Animals Land Animals To get the amount of animals that can be...

Detailed instructions on getting c++-cli set up or installed.

A good way to visualize a 2d array is as a list of lists. Something like this: lst=[[1,2,3],[4,5,6],[7,8,9]] here the outer list lst has three things in it. each of those things is another list: The first one is: [1,2,3], the second one is: [4,5,6] and the third one is: [7,8,9]. You can access ...

import pyglet audio = pyglet.media.load("audio.wav") audio.play() For further information, see pyglet

List in scheme are nothing else than a series of pairs nested in each other in the cdr of a cons. And the last cdr of a proper list is the empty list '(). To create the list (1 2 3 4), we'd have something like this: (cons 4 '()) > (4) (cons 3 (cons 4 '())) > (3 4) (cons 2 (cons 3 (cons 4...

COMMENT ON TABLE table_name IS 'this is student details table';

A enum declares a set of ordered values - the typedef just adds a handy name to this. The 1st element is 0 etc. typedef enum { Monday=1, Tuesday, Wednesday } WORKDAYS; WORKDAYS today = Monday;//value 1

Here’s an example vector asset which we’re actually using in AppCompat: res/drawable/ic_search.xml <vector xmlns:android="..." android:width="24dp" android:height="24dp" android:viewportWidth="24.0" android:viewportHeig...

Here is a simple VectorDrawable in this vectordrawable.xml file. <vector xmlns:android="http://schemas.android.com/apk/res/android" android:height="64dp" android:width="64dp" android:viewportHeight="600" android:viewportWidth=&quot...

Detailed instructions on getting automation set up or installed.

This is for those moving to data.table >= 1.9.8 You have a data set of pet owners and names, but you suspect some repeated data has been captured. library(data.table) DT <- data.table(pet = c("dog","dog","cat","dog"), owner = c(&quot...

SQL Server 2012 / 2014 DECLARE @RowsPerPage INT = 10, @PageNumber INT = 4 SELECT OrderId, ProductId FROM OrderDetail ORDER BY OrderId OFFSET (@PageNumber - 1) * @RowsPerPage ROWS FETCH NEXT @RowsPerPage ROWS ONLY SQL Server 2005/2008/R2 DECLARE @RowsPerPage INT = 10, @PageNumber INT = ...

For getting the next 10 rows just run this query: SELECT * FROM TableName ORDER BY id OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY; Key points to consider when using it: ORDER BY is mandatory to use OFFSET and FETCH clause. OFFSET clause is mandatory with FETCH. You can never use, ORDER BY … FETC...

Since every Applicative Functor is a Functor, fmap can always be used on it; thus the essence of Applicative is the pairing of carried contents, as well as the ability to create it: class Functor f => PairingFunctor f where funit :: f () -- create a context, carrying nothing ...

NSMutableAttributedString * string = [[NSMutableAttributedString alloc] initWithString:@"firstsecondthird"]; [string addAttribute:NSForegroundColorAttributeName value:[UIColor redColor] range:NSMakeRange(0,5)]; [string addAttribute:NSForegroundColorAttributeName value:[UIColor greenColo...

Firebase Cloud Messaging is the Firebase service that handles push notifications. You can add this service in any client: web, Android or IOS. The specific functioning for each must be read from the documentation. For adding FCM in any type of project, is always adding a library. Considering the s...

Dependenct Injection Intro An application is composed of many objects that collaborate with each other. Objects usually depend on other objects to perform some task. When an object is responsible for referencing its own dependencies it leads to a highly coupled, hard-to-test and hard-to-change code...