This article is about sorting and min-max aggregations on character data. When sorting matters, you end your query with an order by. You might think that if you’re sorting on character data, the first value listed would equal the aggregated minimum, and the last value listed would equal the aggregated maximum.
This post is about escaping in Notepad++, escaping from what is commonly called a backslash. It is a typographic mark also denoted by a reverse slash or backslant, among others . When coding, many programming languages recognize this special character as a token to signal the compiler to treat the character following the backslash either normally ( if it would be treated specially when not preceded by the backslash ) or specially ( if it would otherwise be treated normally).
When a whole number needs conversion to a fully spelled out format, the wellknown J/JSP “tric” is readily found. Well, in case, you didn’t, here it is. No, it has nothing to do with Java Server Pages.
When work gets done during business days, that’s what this blog post is about. Moreover, when also the amount of business days is known upfront.
You have a procedure or function returning computed values in out parameters. And you’d like to call it in SQL. How’s that done?
Suppose you are the developer of a database service which can be called any number of times. This database service itself just registers the call, and is allowed to immediately make an outbound call to another service, for example to enhance information presented by the initial inbound call.
How to invoke SQL and/or PL/SQL scripts from Notepad++
Notepad++ might well be your one and only text editor. It’s your favourite editor too, right? But can you run your Oracle SQL*Plus or Oracle PL/SQL commands or scripts from within npp++ at a click of a button ? Yes you can.
Given a list of time intervals defining certain detail time validity, how to determine if these intervals are all subsequent to each other ?
This blog post is about a common problem within application programming. It’s about time validity, specifically about multiple periods of time validity and the question of how to compute the overlapping periods. Time validity is always about something, like a contract period, a lease period, or a subscription period. However, I’d like to keep this post abstract in this respect. I’ll assume that periods are ‘grouped’ by a certain foreign referring to the object having the time validity period. Hence, I use column ‘g’ to refer to this fictitious object.