Oracle 10gR2 – Conditional PL/SQL Compilation – AMIS Oracle and Java Blog

For one of our sessions for the Knowledge Center Oracle Server Development I had to prepare a presentation and demonstration on new Oracle 10gR2 features in SQL and PL/SQL – as well as reflect on some by now somewhat more established 10gR1 features. If you are interested in this presentation, you can download it here... Continue Reading →

Sublime Text (3) for PHP Developers – Matt Stauffer on Laravel, PHP, Frontend development

Sublime Text (3) for php Developers Posted on June 26, 2015 | By Matt Stauffer A lot of folks in the php community have been checking out PHPStorm lately, including myself and most of the developers I work with. We love the code intelligence we get from PHPStorm, but still miss the speed, quick boot-up,... Continue Reading →

RegEx never endig story….

It is example of use RegEx to prepare SQL data for SELECT/UPDATE operation. /^.*/gm ^ asserts position at start of a line .* matches any character (except for line terminators) * Quantifier — Matches between zero and unlimited times, as many times as possible, giving back as needed (greedy) Global pattern flags g modifier: global.... Continue Reading →

SQL corner: 7 kind of SQL Joins. Including : INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

Infographic of the 7 kind of SQL Joins. Including : INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, with or without the intersect. Very useful for web developer. Source : http://sql.sh #SQL #JOIN     Source: Pinterest http://sql.sh/2401-sql-join-infographie Other sources https://docs.oracle.com/cd/B28359_01/server.111/b28286/queries006.htm https://www.techonthenet.com/oracle/joins.php - also include examples and old Oracle notations

SublimeText 3 tips and customization

One of best text editor for Linux and W$ bellow some tips and usefully configuration Regexp conversion to Wiki links Conversion to Wiki links add [ before and ] after text. Find what: (http.{2,}) Relpace to: [\1] Polish letters Polskie znaki diakrytyczne w Sublime Text 3 - dodanie wpisów do Key Bindings - User (na... Continue Reading →

Unique session ID

The UNIQUE_SESSION_ID function returns a character string unique to the session among all sessions currently connected to the database. The return string can be up to 24 bytes in length. Multiple calls to the function from the same session will always return the same string. The program header follows:

Notes UNIQUE_SESSION_ID is functionally identical... Continue Reading →

Arrays of Pointers

9.4 Arrays of Pointers As seen in the last example, sorting an array of strings requires swapping the strings which can require copying a lot of data. For efficiency, it is better to avoid actual swapping of data whenever a data item is large, such as a string or an entire data base record. In... Continue Reading →

Programowanie współbieżne C na Linux – przykłady

Przykładowe zadania z programowania współbieżnego na systemie Linux Napisz program, który pokazuje, które atrybuty procesu macierzystego są dziedziczone przez proces potomny uruchomiony za pomocą funkcji fork(), które zaś otrzymują nową wartość. Napisz program, który pokazuje, które atrybuty procesu są zachowane przez proces po wykonaniu funkcji exec(). Napisz program, który wyświetla identyfikator procesu (PID) i nazwę... Continue Reading →

Automat komórkowy w C | Cellular automaton (CA) in C

Cellular automata and Moore neighborhood Cellular automaton (CA) is by definition a periodic grid of cells, where in each cell sits a finite automaton, and a set of (identical) rules for every such automaton describing to which state it switches on a next moment of discrete time ti+1, depending of its own state and states... Continue Reading →

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑