Tutorial by Examples: on

Even if third-party libraries are good, a simple way to parse the JSON is provided by protocols You can imagine you have got an object Todo as struct Todo { let comment: String } Whenever you receive the JSON, you can handle the plain NSData as shown in the other example using NSJSONSeria...

Static variables and methods are not part of an instance, There will always be a single copy of that variable no matter how many objects you create of a particular class. For example you might want to have an immutable list of constants, it would be a good idea to keep it static and initialize it j...

This creates a table partitioned by hash, 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 HASH(store_id) PARTITIONS 8; You should use a power of 2 for the number of hash ...

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);

JasperSoft Studio If datasource or database connection is needed to fill report, create your Data Adapter in Repository Explorer by right clicking "Data Adapters" selecting "Create Data Adapter" Enter preview mode by selecting the Preview tab (no errors in deign need t...

(Wikipedia) Bioinformatics is an interdisciplinary field that develops methods and software tools for understanding biological data. As an interdisciplinary field of science, bioinformatics combines computer science, statistics, mathematics, and engineering to analyze and interpret biological dat...

When you have multiple subscriptions under your Azure account; it's important that you are selecting the one you wish to operate on (and use this as default); to avoid accidents happening to resources on the wrong subscription. Classic mode Set-AzureSubscription Select-AzureSubscription Resou...

The AND keyword is used to add more conditions to the query. NameAgeGenderSam18MJohn21MBob22MMary23F SELECT name FROM persons WHERE gender = 'M' AND age > 20; This will return: NameJohnBob using OR keyword SELECT name FROM persons WHERE gender = 'M' OR age < 20; This will return: n...

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

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

Start a Script Block as background job: $job = Start-Job -ScriptBlock {Get-Process} Start a script as background job: $job = Start-Job -FilePath "C:\YourFolder\Script.ps1" Start a job using Invoke-Command on a remote machine: $job = Invoke-Command -ComputerName "ComputerName&...