Srini

How to get DATE Only From DATETIME Column

Here is an SQL query to get only Date from the Datetime column. This is tested in Oracle. Also, added SQL query to get both Date and Time.

Understand Flashback Table in Oracle to Recover Deleted Data

Flashback table is an advanced concept in Oracle. With which you can recover data till a specific point in time. Here are the basic architecture and handy SQL queries that you need.

How to Slice a String [Substring] in Python

String slicing examples in python. The methods are positive, negative slicing, with single and double colon operators.

7 Daily Use Python String Functions

In Python, string manipulation methods include find, validate, concatenate, change case, split, replace, and strip.

How to Use Merge Statement in SQL Query: Best Examples

In SQL, MERGE is the latest statement. You can include all UPDATE, INSERT and DELETE statement in single query. Major RDBMS databases support this statement.

EBS Block Storage in AWS The Real Usage

Block storage volumes are persistent. These have a relationship to the EC2 instance. Here is the usage of EBS storage in AWS.

How to Monitor AWS RDS Service

AWS operations team will monitor RDS services. Here are a few ideas on monitoring the RDS service. Helpful for AWS engineers.

COBOL Sequential Vs. Indexed: These are Top Differences

Understand the differences between sequential and indexed files. The given syntax is helpful to write a COBOL program using sequential and indexed files.

Exclusive 10 Interview Questions on AWS Operations

The operations team plays a crucial role in monitoring AWS resources. Here you will find basic questions on AWS ECS monitoring.

Exploring Python’s OOP Principles with Examples

Here’s a quick explanation of Python Object-oriented concepts. These are useful to say in interviews.

AWS Container Service (ECS) Real Use of It

Before you go into deep dive into the ECS service of AWS, here are the top methods and why you need to use them to deploy containers.

Two Types of PLSQL Cursors: What are those?

Explained the different types of PLSQL cursors. Helpful for all developers who worked on PLSQL.