-
How to Recover Deleted Rows in Oracle — Simplified
In our workshop, a team member accidentally deleted table rows, but we used Oracle flashback query to recover. Read More ⇢
-
How to Extract DATE and TIME from TIMESTAMP: DB2
The easy ways to extract DATE and TIME in DB2. Use these examples in your project at once. Also, these examples are for you to do DATE and TIME calculations. Read More ⇢
-
Top 10 SQL Queries for Efficient Data Transformation
Discover essential SQL queries for transforming raw data into actionable insights. Ideal for ETL processes and real-world projects. Read More ⇢
-
Microland Interview: 2 Tricky Linux Shell Scripts
In the Microland interview, they asked Linux Shell script questions on automation for software updates and security audit on multiple servers. Read More ⇢
-
Optimize SQL Queries with Custom User-Defined Functions
Enhance your SQL skills with User-Defined Functions (UDFs). Learn how scalar, table-valued, and aggregate functions help improve query performance and enable custom logic in SQL. Read More ⇢
-
A Comprehensive Overview of DB2 Catalog Table Schemas
DB2 catalog tables are system-generated during database creation, providing information about database objects and are organized under various schemas. Read More ⇢
-
Python and SQL Interview Questions at KPMG: A Handy Checklist
The content comprises potential interview questions and related responses for a Python and SQL developer role at KPMG, covering topics like database operations, Python data structures, and CSV file handling in Pandas. Read More ⇢
-
Python Strings: Center Vs Join Methods
Python’s center method aligns a string within a specified width, while the join method concatenates strings using a specified delimiter. Read More ⇢
-
SQL Like Statement with CHAR and VARCHAR: Top Differences
The post explains the differences in using the SQL Like statement with Char and Varchar, particularly regarding trailing spaces. Read More ⇢
Advertisements
Srinimf 