Tutorial by Examples: ar

This creates a table partitioned by ranges, in this example on order values. CREATE TABLE orders ( order_nr NUMBER(15), user_id VARCHAR2(2), order_value NUMBER(15), store_id NUMBER(5) ) PARTITION BY RANGE(order_value) ( PARTITION p1 VALUES LESS THAN(10), PARTITION ...

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...

ALTER TABLE table_name DROP PARTITION partition_name;

Select data from a partition SELECT * FROM orders PARTITION(partition_name);

ALTER TABLE table_name TRUNCATE PARTITION partition_name;

ALTER TABLE table_name RENAME PARTITION p3 TO p6;

ALTER TABLE table_name MOVE PARTITION partition_name TABLESPACE tablespace_name;

ALTER TABLE table_name ADD PARTITION new_partition VALUES LESS THAN(400);

When working with Azure using PowerShell there are 2 different ways you should be aware of and you will see a lot of the Microsoft documentation referring to both of them: "Classic mode (Service Management)" This is the old way of operating Azure and managing Azure. There is still some s...

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...

ggplot(data = diamonds, aes(x = cut, fill =color)) + geom_bar(stat = "count", position = "dodge") it is possible to obtain an horizontal bar chart simply adding coord_flip() aesthetic to the ggplot object: ggplot(data = diamonds, aes(x = cut, fill =color)) + geom_ba...

async.parallel(tasks, afterTasksCallback) will execute a set of tasks in parallel and wait the end of all tasks (reported by the call of callback function). When tasks are finished, async call the main callback with all errors and all results of tasks. function shortTimeFunction(callback) { set...

Firstly, one can use quiver, where one doesn't have to deal with unhandy normalized figure units by use of annotation drawArrow = @(x,y) quiver( x(1),y(1),x(2)-x(1),y(2)-y(1),0 ) x1 = [10 30]; y1 = [10 30]; drawArrow(x1,y1); hold on x2 = [25 15]; y2 = [15 25]; drawArrow(x2,y2) ...

2009 uses Character; var C1, C2: Char; begin C1 := 'F'; C2 := ToLower(C1); // Convert the char to lower-case C1 := ToUpper(C2); // Convert the char to upper-case The uses clause should be System.Character if version is XE2 or above.

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...

Option Compare Binary Binary comparison makes all checks for string equality within a module/class case sensitive. Technically, with this option, string comparisons are performed using sort order of the binary representations of each character. A < B < E < Z < a < b < e < z ...

set can also be invoked with just one argument. When called with just one argument, it returns the contents of that argument. % set x 235 235 % set x 235

In VB.NET, every variable must be declared before it is used (If Option Explicit is set to On). There are two ways of declaring variables: Inside a Function or a Sub: Dim w 'Declares a variable named w of type Object (invalid if Option Strict is On) Dim x As String 'Declares a variable named ...