Tutorial by Examples: st

Check existing partitions on Schema SELECT * FROM user_tab_partitions;

This creates a table partitioned by lists, in this example on store id. CREATE TABLE orders ( order_nr NUMBER(15), user_id VARCHAR2(2), order_value NUMBER(15), store_id NUMBER(5) ) PARTITION BY LIST(store_id) ( PARTITION p1 VALUES (1,2,3), PARTITION p2 VALUES(4,5,6...

Delphi has the following string types (in order of popularity): TypeMaximum lengthMinimum sizeDescriptionstring2GB16 bytesA managed string. An alias for AnsiString through Delphi 2007, and an alias for UnicodeString as of Delphi 2009.UnicodeString2GB16 bytesA managed string in UTF-16 format.AnsiStr...

A string resource provides text strings for your application with optional text styling and formatting. There are three types of resources that can provide your application with strings: String XML resource that provides a single string. Syntax: <?xml version="1.0" encoding="...

When working with existing model that is quite big and is being regenerated quite often in cases where abstraction needed it might be costly to manually go around redecorating model with interfaces. In such cases one might want to add some dynamic behavior to model generation. Following example wil...

Some ADO.NET providers (most notably: OleDB) do not support named parameters; parameters are instead specified only by position, with the ? place-holder. Dapper would not know what member to use for these, so dapper allows an alternative syntax, ?foo?; this would be the same as @foo or :foo in other...

angular .module('MyApp', []) .constant('VERSION', 1.0); Your constant is now declared and can be injected in a controller, a service, a factory, a provider, and even in a config method: angular .module('MyApp') .controller('FooterController', function(VERSION) { this.version = V...

extern int var; static int var; /* Undefined behaviour */ C11, §6.2.2, 7 says: If, within a translation unit, the same identifier appears with both internal and external linkage, the behavior is undefined. Note that if an prior declaration of an identifier is visible then it'll have the pri...

Use the yum command to manage packages in Enterprise Linux-based operating systems: yum install php This installs a minimal install of PHP including some common features. If you need additional modules, you will need to install them separately. Once again, you can use yum to search for these pac...

uses System.Character; var S1, S2: string; begin S1 := 'Foo'; S2 := ToLower(S1); // Convert the string to lower-case S1 := ToUpper(S2); // Convert the string to upper-case

enum Util { /* No instances */; public static int clamp(int min, int max, int i) { return Math.min(Math.max(i, min), max); } // other utility methods... } Just as enum can be used for singletons (1 instance classes), it can be used for utility classes (0 instance...

Imagine that we have a class Math.php with logic of calculating of fiobanacci and factorial numbers. Something like this: <?php class Math { public function fibonacci($n) { if (is_int($n) && $n > 0) { $elements = array(); $elements[1] = 1; ...

The http_build_query() will create a query string from an array or object. These strings can be appended to a URL to create a GET request, or used in a POST request with, for example, cURL. $parameters = array( 'parameter1' => 'foo', 'parameter2' => 'bar', ); $queryString = http_b...

<PropertyGroup> <!-- Definition of a Property named "TestCondition". A PropertyGroup may also be placed inside a Target. --> <TestCondition>True</TestCondition> </PropertyGroup> <!-- This Target will run after the "Clean" Target, su...

The DISTINCT clause after SELECT eliminates duplicate rows from the result set. CREATE TABLE `car` ( `car_id` INT UNSIGNED NOT NULL PRIMARY KEY, `name` VARCHAR(20), `price` DECIMAL(8,2) ); INSERT INTO CAR (`car_id`, `name`, `price`) VALUES (1, 'Audi A1', '20000'); INSERT INTO CA...

A quick note before actually installing RabbitMQ: Ubuntu 14.04's Erlang packages have issues if you are using SSL with RabbitMQ, so you'll need to install a newer version than what the Ubuntu package maintainers provide, so use the binaries at https://www.erlang-solutions.com/resources/download.html...

Here are examples of how to use monotonic predicates instead of impure, non-monotonic constructs in your programs: dif/2 is meant to be used instead of non-monotonic constructs like (\=)/2 arithmetic constraints (CLP(FD), CLP(Q) and others) are meant to be used instead of moded arithmetic predi...

List<Integer> nums = Arrays.asList(1, 2, 3); List<String> strings = nums.stream() .map(Object::toString) .collect(Collectors.toList()); That is: Create a stream from the list Map each element using Object::toString Collect the String values into a List using Collectors...

Below code is simple java program using selenium. The journey of the below code is Open Firefox browser Open google page Print title of Google page Find the search box location Pass the value as Selenium in the search box Submit the form Shutdown the browser package org.openqa.selenium....

Go to https://www.arduino.cc/en/Main/Software Click the Mac OS X link. Unzip the .zipfile. Move the Arduino application to Applications.