Assuming we have a task to update XML data stored in Oracle database table. Let it be XMLTYPE column. Actually it can either be CLOB or BLOB. Does not make big sense, because can go though conversions to XMLTYPE anyway. Just matter of performance. Here I’ll provide sample, how to proceed in 2 cases: Update XML by changing values in…
How to open file in Source View instead of Design View by default in JDeveloper?
Most of JDeveloper users complain about its performance. There are number of ways to improve it by tuning various parameters in configuration files. If you’ve done it already you might still face long opening of different file types (most common – .jspx, .jsf, .jsff, etc.). That is because JDeveloper is trying to open it in Design View. It tries to…
How to enable debugging of ACL security rules in ServiceNow?
One of the core and powerful features in ServiceNow is ACL (Access Control List) management. Multiple levels of ACL definitions for tables, records and fields might lead into confusing debugging of operations and visibility of certain application areas. Things become easier by leveraging special debugging feature for ACLs. It can be enabled by clicking on: System Security -> Debugging ->…
ServiceNow Certified System Administrator (CSA) exam. Personal experience.
It happened that I’ve passed ServiceNow CSA exam recently. There were 60 questions and 90 minutes. That was completely enough time, because some questions were really short with just True/False answers and took just few seconds to answer. Some were really long with as long answers. Those could take even more than a minute. But long question with long answers…
D in SOLID – Dependency Inversion Principle. Short explanation with example.
Here are 3 statements, all of which means the same thing: Depend upon Abstractions. Do not depend upon concretions. High-level modules should not depend on low-level modules. Both should depend on abstractions. Abstractions should not depend on details. Details should depend on abstractions. This principle was introduced by Robert Martin together with the rest 4 SOLID principles. In my opinion it…
I in SOLID – Interface Segregation Principle. Short explanation with example.
Clients should not be forced to depend upon interfaces that they do not use Rober Martin This principle, similar to Single Responsibility Principal, is about avoiding redundant code changes when requirements change. Following this principle will save you from changing existing classes, allows to add extra functionality with just an extra class. We could also redefine this principle like this:…
L in SOLID – Liskov Substitution Principle. Short explanation with example.
Let Φ(x) be a property provable about objects x of type T. Then Φ(y) should be true for objects y of type S where S is a subtype of T. Barbara Liskov Sounds so confusing… But really it is not so complicated, just lets first redefine it like this: Objects of a superclass shall be replaceable with objects of its subclasses without breaking the application. That requires the objects of your subclasses to behave…
How to check memory (RAM) usage in Linux?
Once we face some memory issues in linux server, usually first of all check disk space. It might be the case that some applications stuffed it with log files or some other content. Here are few instructions how to do that – How to identify which files take most of the disk space in Linux?. However disk space might be totally…
O in SOLID – Open/Closed Principle. Short explanation with example.
Software entities (classes, modules, functions, etc.) should be open for extension, but closed for modification Bertrand Meyer This statement was introduced by Bertrand Meyer in 1988. And it basically means that: A class is treated as open if it is available for extension. I.e. possible to extend by adding extra attributes or methods. A class is treated as closed, if…
S in SOLID – Single Responsibility Principle. Short explanation with example.
A class should have one and only one reason to change Robert Cecil Martin This is what was introduced by Robert Martin many years ago. We can translate it to like this: “A class has to be dedicated only for one purpose”, “A class has to be responsible for only one task”. You can also face a term like High/Low…