Tutorial by Examples: ti

$ IFS= read -r foo <<EOF > this is a \n line >EOF $ printf '%s\n' "$foo" this is a \n line

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

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

Magento custom module development is a core part of any Magento development or Magento project, because at any stage you may want to integrate your own functionality/module in your existing Magento project. The first thing developers should disable is the system cache. Otherwise developing will bec...

Create a new project with the Leiningen figwheel template: lein new figwheel hello-world Run Figwheel: cd hello-world lein figwheel After a moment it will start a development webserver and open the page in your browser. It also opens a Clojurescript REPL connected to the browser. Try enter...

:s/foo/bar/c Marks the first instance of foo on the line and asks for confirmation for substitution with bar :%s/foo/bar/gc Marks consecutively every match of foo in the file and asks for confirmation for substitution with bar

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

It's possible to pass Java objects to Nashorn engine to be processed in Java code. At the same time, there are some JavaScript (and Nashorn) specific constructions, and it's not always clear how they work with java objects. Below there is a table which describes behaviour of native Java objects ins...