Srini

How to Write Complex SQL Sub-query

Here is a sample sub-query. Here you will read records from two tables. Also explained how the query works.

How to Run Stored Procedure in SQL Developer

Here are steps of how to create a procedure in SQL developer and how to call it.

13 Essential Python Interview Questions

Here are 13 essential python interview questions useful to crack your interview.

How to Find Sum of Series in Python

Sample Python script to calculate the sum of the GP series. Knowing the skills applied to write this script useful for interviews.

How to Print Name[String] in Reverse order in Python

Here’s a python program that reverses the name you enter and prints it in reverse order. This is useful for interviews.

Bash: How to Calculate Sum After Reading File

Here is a shell script to calculate the sum of input file records. And to replace a string with a new one using sed utility.

How to Create a JSON File in Python: Step-by-Step Guide for Beginners

JSON files are popular in message interchange. Here is sample python logic on how to write JSON data to a file using the dump function

How to Effectively Use sed for Search and Replace in Bash

Here are the best examples of how to use sed utility to search and replace. These examples explain how to replace a string with your choice.

How to get CPU Utilisation of SQL Query

Here’s a sample Explain plan query to find statistics of the execution plan. Useful for SQL and Data warehousing developers.

How to Call a Shell Script from Another Script

In Bash shell (or any other) you can include a script in another script. Here is best example of how you can do it. Also, I have explained the reasons of why you need it.

DB2 Check Vs. Default Constraint Top Differences

Check and Default constraints are both not the same. They create during create Table. Differences between these you can understand with these examples.

Exclusive Loops Vs Iterators in Python

Loops and iterators are two unique concepts. But the outcome is the same. Here are details explained with simple examples.