Tutorial by Examples: u

WITH RECURSIVE t(n) AS ( VALUES (1) UNION ALL SELECT n+1 FROM t WHERE n < 100 ) SELECT sum(n) FROM t; Link to Documentation

The following code will attempt to execute loadFromHttp() up to 5 times (maxAttempts), with each attempt delayed by as many seconds. If maxAttempts is surpassed, the Observable gives up. // assume loadFromHttp() returns a Promise, which might fail. Rx.Observable.from(loadFromHttp()) ....

Dictionaries can be constructed by passing it any number of pairs. julia> Dict("A"=>1, "B"=>2) Dict{String,Int64} with 2 entries: "B" => 2 "A" => 1 You can get entries in a dictionary putting the key in square brackets. julia> dic...

Converting date and time strings to numeric arrays can be done with datenum, though it may take as much as half the time of reading a large data file. Consider the data in example Textscan. By, again, using textscan and interpret date and time as integers, they can rapidly be converted into a numer...

Safari To return the URL of the current tab in Safari, use URL of current tab: tell application "Safari" return URL of current tab of window 1 end tell Google Chrome To return the URL of the current tab in Google Chrome, use URL of active tab: tell application "Google Chr...

See the download page to manually download and unpack the latest version, or follow the links below: spring-boot-cli-1.5.1.RELEASE-bin.zip spring-boot-cli-1.5.1.RELEASE-bin.tar.gz

Button API provides an easy way to assign common keyboard shortcuts to buttons without the need to access accelerators' list assigned to Scene or explicitly listening to the key events. Namely, two convenience methods are provided: setDefaultButton and setCancelButton: Setting setDefaultButton ...

Detailed instructions on getting gmail-api set up or installed.

BigDecimal provides static properties for the numbers zero, one and ten. It's good practise to use these instead of using the actual numbers: BigDecimal.ZERO BigDecimal.ONE BigDecimal.TEN By using the static properties, you avoid an unnecessary instantiation, also you've got a literal in you...

/** * Save the results from the saved search as .csv and store in file cabinet * Get the file's internal id when loading the file * Use \n to process each row * Get the internal id and whatever columns that need updating * Create a filtered search and pass the internal id * If the passe...

If you have the following data file cat data.csv 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 maybe you need to read the fourth column of the third line, this would be "24" awk 'NR==3 ...

Parent Component : Initialize users lists. @Component({ selector: 'parent-component', template: '<div> <child-component [users]="users"></child-component> </div>' }) export class ParentComponent implements OnInit{ let users...

// Add MPVolumeView in a holder view let mpVolumeHolderView = UIView(frame: CGRect(x: 0, y: view.bounds.midY, width: view.bounds.width, height: view.bounds.height)) // Set the holder view's background color to transparent mpVolumeHolderView.backgroundColor = .clear let mpVolume = MPVolumeView(fr...

Sweave from the utils package allows for formatting code, prose, graphs and tables together in a LaTeX document. Further Resources Knitr and RMarkdown

In quite a few cases your frame might not show up immediately and you probably have to wait till it is loaded to switch. Or else you will have NoSuchFrameException. So its always a good choice to wait before you switch. Following is a ideal way to wait till a frame is loaded. try{ new Web...

This example assumes two servers: dbserver (where our database lives) appclient (where our applications live) FWIW, both servers are SELinux enforcing. First, log on to dbserver Create a temporary directory for creating the certificates. mkdir /root/certs/mysql/ && cd /root/cer...

SELECT DISTINCT object_name(i.object_id) AS [Object Name], c.name AS [Partition Column], s.name AS [Partition Scheme], pf.name AS [Partition Function], prv.tot AS [Partition Count], prv.miVal AS [Min Boundry Value], prv.maVal AS [Max Boundry Value] FROM sys.object...

The autocomplete UI control is a search dialog with built-in autocomplete functionality. As a user enters search terms, the control presents a list of predicted places to choose from. When the user makes a selection, a GMSPlace (Place in Xamarin) instance is returned, which your app can then use to ...

Create @myjson variable as JSON type (read more): SET @myjson = CAST('["A","B",{"id":1,"label":"C"}]' as JSON) ; SELECT some members! SELECT JSON_EXTRACT( @myjson , '$[1]' ) , JSON_EXTRACT( @myjson , '$[*].label') , JSON_EXTRACT( @...

Interrupts are handled by a protected procedure with no parameters. ------------------------------------------------------------------ -- Interrupt Counting Package -- ------------------------------------------------------------------ with Ada.Interrupts.Names; use Ada.Interrupts.Names; packa...