Tutorial by Examples: p

In Oracle 12g+ SELECT Id, Col1 FROM TableName ORDER BY Id OFFSET 20 ROWS FETCH NEXT 20 ROWS ONLY; In earlier Versions SELECT Id, Col1 FROM (SELECT Id, Col1, row_number() over (order by Id) RowNumber FROM TableName) WHERE RowNumber BETWEEN 21 AND 40 ...

In Oracle 12g+ SELECT Id, Col1 FROM TableName ORDER BY Id OFFSET 5 ROWS; In earlier Versions SELECT Id, Col1 FROM (SELECT Id, Col1, row_number() over (order by Id) RowNumber FROM TableName) WHERE RowNumber > 20

It's quite common to want to check the status of the various partitions/drives on your server/computer to see how full they are. The following command is the one you'll want to run: df -h This will produce output similar to the following: [root@mail ~]# df -h Filesystem Size Used A...

$color-purple-bg: #AF6EC4; $color-purple-border: #5D0C66; $color-yellow-bg: #E8CB48; $color-yellow-border: #757526; .tooltip { position: relative; &--arrow-down { @include pointer('bottom', 30px, ($color-purple-border, $color-purple-bg), 15px); } ...

// GET: Student/Edit/5 // It is receives a get http request for the controller Student and Action Edit with the id of 5 public ActionResult Edit(int? id) { // it good practice to consider that things could go wrong so,it is wise to have a validation in the controller ...

(ns so-doc.events) (enable-console-print!) (defn click-event [] (println "Button clicked")) (defn load-event [] (println "Page loaded!") (.addEventListener (.getElementById js/document "btn") "click" click-event false)) (.addEventListener ...

$collection = Mage::getModel('catalog/product') ->getCollection() ->setPageSize(20) ->setCurPage(1);

Large scale applications often need different properties when running on different environments. we can achieve this by passing arguments to NodeJs application and using same argument in node process to load specific environment property file. Suppose we have two property files for different enviro...

Separate the construction of a complex object from its representation so that the same construction process can create different representations and and provides a high level of control over the assembly of the objects. In this example demonstrates the Builder pattern in which different vehicles ar...

Specify the kind of objects to create using a prototypical instance, and create new objects by copying this prototype. In this example demonstrates the Prototype pattern in which new Color objects are created by copying pre-existing, user-defined Colors of the same type. using System; using Syste...

Provide an interface for creating families of related or dependent objects without specifying their concrete classes. In this example demonstrates the creation of different animal worlds for a computer game using different factories. Although the animals created by the Continent factories are diffe...

while true; do echo ok done or while :; do echo ok done or until false; do echo ok done

Vim plugins are addons that can be used to change or enhance functionality of vim. There is a good list of plugins at vimawesome

Show how to use cv::VideoCapture with e.g. a webcam. Capturing frames from webcam and display it. Here is the example code: #include <iostream> #include "opencv2/highgui/highgui.hpp" #include "opencv2/imgproc/imgproc.hpp" #include "opencv2/core/core.hpp" ...

using System; using Xamarin.Forms; namespace contact_picker { public class App : Application { public App () { // The root page of your application MainPage = new MyPage(); } protected override void OnStart () ...

using System; using Xamarin.Forms; namespace contact_picker { public class MyPage : ContentPage { Button button; public MyPage () { button = new Button { Text = "choose contact" }; button....

using System; using Xamarin.Forms; namespace contact_picker { public class ChooseContactPage : ContentPage { public ChooseContactPage () { } } }

Sample table (say Employee) structure Column NameDatatypeIDINTF_NameSTRINGL_NameSTRINGPhoneSTRINGAddressSTRING Project all the columns Use wild card * to project all the columns. e.g. Select * from Employee Project selected columns (say ID, Name) Use name of columns in the projection list. e...

If the input HTML DOM is <html> <body> <a>link</a> <div class='container' id='divone'> <p class='common' id='enclosedone'>Element One</p> <p class='common' id='enclosedtwo'>Element Two</p> ...

To convert px to em or rem you can use the following function: @function rem-calc($size, $font-size : $font-size) { $font-size: $font-size + 0px; $remSize: $size / $font-size; @return #{$remSize}rem; } @function em-calc($size, $font-size : $font-size) { $font-size: $font-siz...