Oracle SQL: LAG Oracle 11g is analytic function

Very usefully new features in Oracle 11g is analytic Oracle SQL function LAG. SQL query LAG This code find change in address post code in journal table: Test query data SQL result site_number jn_datetime adr_postcode prev_adr_postcode 20001 2017-08-01 15:01:31 00-001 00-003 How it works together http://sqlfiddle.com/#!4/9a676b/1

Python rename special characters in filename

Problem: when upload files to One Drive i have problem with files contain special characters. Find solution: Sources: http://www.mtu.edu/umc/services/digital/writing/characters-avoid/ https://stackoverflow.com/questions/2759067/rename-multiple-files-in-a-directory-in-python https://ideone.com/RH1LrL https://serverfault.com/questions/348482/how-to-remove-invalid-characters-from-filenames

The Qualities of Carrots Carrots have many qualities—sweet, bitter, pungent, heating, light, sharp. For pitta, go easy on the chili, garlic, mustard seeds, and hing and eat in moderation. Cooked carrots are sweet and heating with a pungent vipaka, so this recipe is particularly balancing for vata and kapha. Medicinal Uses: A good food for... Continue Reading →

Customize yours WordPress editor

I had problem add code to articles somethings like add name of classes or variables in different CSS format. Here is tips how configure your WordPress editor to do it: https://stackoverflow.com/questions/7153599/add-code-button-to-wordpress-tinymce https://www.sitepoint.com/adding-custom-functionality-to-the-wordpress-visual-editor/

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 →

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

Up ↑