SQL owa_util.get_procedure and $$PLSQL_UNIT

In 10g and 11g I use the "owa_util.get_procedure" function. I normally use this in packages as it will also return the name of an internal procedure or function as part of the package name, i.e. (package_name).(procedure name). I use this to provide a generic EXCEPTION template for identifying where an exception occured. Source: https://stackoverflow.com/questions/286549/find-out-name-of-pl-sql-procedure#286569 Return... Continue Reading →

Oracle SQL: LAG Oracle 11g is analytic function

Very usefully new features in Oracle 11g is analytic function LAG Query This code find change in address post code in journal table Test data Result site_number jn_datetime adr_postcode prev_adr_postcode 20001 2017-08-01 15:01:31 00-001 10-001 20002 2017-04-20 11:59:29 00-001 20-002 20003 2017-06-15 04:02:41 00-001 30-003   http://sqlfiddle.com/#!4/57db1f/2/0

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/

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

Up ↑