18/10/2016

Appenzello

Trust me, it's as easy as walking into a cake while stealing candies from a baby


Click on the image to view the full album

09/10/2016

Basel among dangerous animals

An Italian, a French and a German walk into a Basel


and it's full of dangerous animals. They all looked relieved there was a glass between us.

Click on the image to view the full album

08/10/2016

[Oracle] SQL SELECT cast to table

In Oracle it is possible to cast one type to another simply by using the CAST keyword.

This also applies to collections, meaning that the result of a SELECT can be casted to varray or nested table; in this case it is necessary to add the MULTISET keyword and make sure that all elements in the collection have a valid match.

Eg suppose you have a type:

CREATE TYPE int_list AS TABLE OF NUMBER(9);

You can run a query that selects some integers and cast the result set to int_list:

SELECT
  CAST(
    MULTISET(
      SELECT t.int_value
      FROM myTable t
    )
   AS int_list)
FROM dual;


[Sheet music] Geometry Dash

Geometry Dash is an ok mobile game with awesome soundtrack, here are some music sheets:

- Cycles
- Dry out
- Back on track
- Theory of everything
- Polargeist
- Jumper
- Can't let go
- Time machine

[Sheet music] Monkey Island

Here are some Music sheets from Monkey Island:

- Main theme
- The Scumm Bar
- A pirate I was meant to be (Monkey Island 3)