Oracle Hierarchical Queries (START WITH ... CONNECT BY ...) are great for selecting tree-like views using single SQL query and still be able to sort them as intended. Things are getting complicated when We trying to use them in framework Query Builder, like this one in Yii 2.
Recently when working with Oracle Data Pump I got strange error, that got like 2 results on Google, non of them solving the issue. So I thought I would share a solution.
(więcej…)
SQLite Database Browser to niewielkie, proste i przyjemne narzędzie do pracy z bazami danych SQLite udostępniane na zasadach public domain.
Jeśli jednak będziemy chcieli użyć tego narzędzia do pracy z bazą danych SQLite 2 będziemy musieli (więcej…)