PLSQL NOT_DATA_FOUND and CURSORS

Here we are common problem in PLSQL. We try find answer for one common question in programing databases. Is the specyfic record exist in other table or not exist? Some examples below show how to menage this problem: In line 11 and 14 we have place to insert own code. Other solution we found when... Continue Reading →

AgilePM Fundation v2

Material to study and learn: https://www.mindmeister.com/287712070/agilepm-agile-project-management-study-guide-mind-map https://www.mindmeister.com/425542788/agile-world https://www.mindmeister.com/468395344/agile-foundation-by-agile-consortium

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 about JOIN https://docs.oracle.com/cd/B28359_01/server.111/b28286/queries006.htm https://www.techonthenet.com/oracle/joins.php - This Oracle tutorial explains how to use JOINS (inner and outer) in... Continue Reading →

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 →

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 →

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

Up ↑