Author: Manpreet Singh

Common Table Expressions (CTE) CTE: WITH ordersWith100OrMoreAmount AS ( SELECT customer_name, order_date FROM orders WHERE order_amount > 100 ) SELECT * FROM ordersWith100OrMoreAmount; CTE With Recursion: Returns list of all the employee ids who are managers of one or more employees:WITH managers (employee_id, manager_id, emp_level) AS (SELECT employee_id, manager_id, 1 FROM employeesWHERE manager_id IS NULLUNION…

In our fast-paced world, where even your coffee needs a coffee, being productive is key—especially if you’re a developer wrangling with databases all day. Oracle SQL Developer is a trusty sidekick for managing databases, but let’s face it, many of us aren’t exactly milking it for all it’s worth. This article will reveal the hidden…

In the dynamic world of database management, SQL is the essential toolkit for Oracle DBAs. It’s the language they use daily to keep the systems running smoothly, secure the data, and ensure peak performance. But which SQL commands do they turn to most often? This article takes you inside the world of an Oracle DBA,…

How StringBuffer maintains capacity?

While serialization using Jackson JsonCreator.Mode.PROPERTIES, in the serialized string, by default, Jackson assumes class attribute names as JSON object keys. BTW, Jackson is high-performance JSON processor library in Java. And, In Jackson, @JsonCreator.Mode.PROPERTIES is a constant used with the @JsonCreator annotation on constructors to specify how arguments for deserialization should be bound from incoming JSON…

Image source: Canva AI In certain cases, it’s crucial for specific classes to exist in just a single instance. There are numerous objects where having only one instance is necessary. Creating multiple instances can lead to issues like incorrect program behavior, excessive resource consumption, or unpredictable outcomes. For instance, you typically require only one object…

In the rapidly evolving landscape of web development, the days of developing applications in a monolithic fashion have become increasingly rare. Whether this shift is advantageous or detrimental remains a subject of debate. However, it undeniably adds a layer of complexity to the deployment process. A common practice now involves maintaining separate Docker images for…