Tutorial by Examples: n

Use the analytical function row_number(): with t as ( select col1 , col2 , row_number() over (order by col1, col2) rn from table ) select col1 , col2 from t where rn between N and M; -- N and M are both inclusive Oracle 12c handles this more easily with OFFSET and FETCH.

TestNG allows defining groups which can include other groups. MetaGroups logically combine one or more group(s) and control the execution of the @Testmethods belonging to those groups. In below example there are various @Test methods belonging to different group(s). Few are specific to particular s...

Create a new browser bookmark, for example, in Chrome click the star icon at the right in the address bar, make sure the Folder is Bookmarks Bar, and then click the Edit... button: In the edit box that opens paste the following code as the URL: javascript:(function(){var root=(window.location.pa...

If you were to hide a link by setting display: none in the CSS then screen readers wouldn’t find it. Instead, we position it absolutely, with clipping. CSS .offscreen { position: absolute; clip: rect(1px 1px 1px 1px); /* for Internet Explorer */ clip: rect(1px, 1px, 1px, 1px); padding: 0; b...

There are a few way's to install WebSocket's to your project. Here are some example's: npm install --save ws or inside your package.json using: "dependencies": { "ws": "*" },

To add ws to your file's simply use: var ws = require('ws');

To open a new WebSocket, simply add something like: var WebSocket = require("ws"); var ws = new WebSocket("ws://host:8080/OptionalPathName); // Continue on with your code... Or to open a server, use: var WebSocketServer = require("ws").Server; var ws = new WebSocketS...

Spinner It is a type of dropdown input. Firstly in layout <Spinner android:id="@+id/spinner" <!-- id to refer this spinner from JAVA--> android:layout_width="match_parent" android:layout_height="wrap_content"> </Spinner> ...

add_action('wp_head','hook_javascript'); function hook_javascript() { $output="<script> alert('Page is loading...'); </script>"; echo $output; }

Basic docs can be found here app.get('/path/:id(\\d+)', function (req, res, next) { // please note: "next" is passed if (req.params.id == 0) // validate param return next(new Error('Id is 0')); // go to first Error handler, see below // Catch error on sync operation ...

app.use() and middleware can be used for "before" and a combination of the close and finish events can be used for "after". app.use(function (req, res, next) { function afterResponse() { res.removeListener('finish', afterResponse); res.removeListener('clos...

When required you can tell Docker to execute additional commands on an already running container using the exec command. You need the container's ID which you can get with docker ps. docker exec 294fbc4c24b3 echo "Hello World" You can attach an interactive shell if you use the -it option...

esc_html should be used anytime we're outputting data inside HTML code. <h4><?php echo esc_html( $title ); ?></h4>

esc_js() is intended to be used for inline JS, inside a tag attribute. For data inside a <script> tag use wp_json_encode(). <input type="text" onfocus="if( this.value == '<?php echo esc_js( $fields['input_text'] ); ?>' ) { this.value = ''; }" name="name&quot...

<textarea><?php echo esc_textarea( $text ); ?></textarea>

String base64="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/="; void setup() { Serial.begin(9600); // Turn the serial protocol ON Serial.println("Start Typing"); } void loop() { if (Serial.available() > 0) { // Check if data has bee...

One of the most important things to learn when you are making a WordPress theme is the WordPress Template hierarchy for themes. The template hierarchy defines what template file that will be loaded for each request and in what order. If the first template does not exist in the hierarchy WordPress wi...

1. Include the font in your Xcode project. 2. Make sure that they are included in the Target Membership column Click on the font from the navigator, and check if the font included. 3. Check if the font included as Resource in your bundle click on your Xcode project file, select "Build P...

After you obtained BluetoothDevice, you can communicate with it. This kind of communication performed by using socket input\output streams: Those are the basic steps for Bluetooth communication establishment: 1) Initialize socket: private BluetoothSocket _socket; //... public InitializeSock...

Install symfony correctly as guided above. Start symfony server if you are not installed in www directory. Ensure http://localhost:8000 is working if symfony server is used. Now it is ready to play with simplest example. Add following code in a new file /src/AppBundle/Controller/MyController.p...