PostgreSQL

How to Install PostgreSQL on Mac

All Data Types in PostgreSQL 14.0

How to do Date/Time operations in PostgreSQL

PostgreSQL Date/Time Functions with examples

PostgreSQL Formatting Functions like to_char, to_date etc.

PostgreSQL Mathematical Functions and Operators with examples

PostgreSQL String Functions and Operators with examples

PostgreSQL bytea or BLOB data type and related Functions and Operators

PostgreSQL Pattern Matching (like, regexp) with examples

PostgreSQL to_char (numeric) with practical examples

PostgreSQL to_char (date/time) with practical examples

How do I Create a basic Table in PostgreSQL

PostgreSQL XML Functions and Operators

PostgreSQL Json Functions and Operators

How to create a Sequence in PostgreSQL

PostgreSQL Sequence Manipulation Functions

How to write CASE query in PostgreSQL

PostgreSQL Conditional expression

PostgreSQL Array Functions and Operators

PostgreSQL Range Functions and Operators

PostgreSQL Aggregate Functions

PostgreSQL Window Functions

PostgreSQL Subquery Expressions

How to generate time series data in PostgreSQL

PostgreSQL Insert Query

How to limit query result in PostgreSQL

How to convert one data type to another in PostgreSQL

Oracle PL/SQL

What is Oracle Database ?

Select statement Oracle

What is DUAL table in Oracle

Oracle MAX function

Oracle MIN function

Oracle AVG function

Oracle COUNT function

Oracle IN clause

Oracle ANY operator

Oracle SOME operator

Oracle Subquery

Oracle ABS function

Oracle MOD function

Oracle REMAINDER function

Oracle SUM function

Oracle RANK function

Oracle DENSE_RANK function

How to find Nth highest salary Oracle

Oracle DECODE function

What is NULL in Oracle

Oracle NVL function

Oracle SUBSTR function

Install oracle 11g on windows 7

Oracle INSTR function

Oracle CASE statement

Difference between DECODE and CASE in Oracle

ALTER table oracle

Oracle interview questions and answers

Oracle COALESCE function

Oracle Sequence

Oracle NVL2 function

Autonomous Transaction in Oracle

Difference between UNION and UNION ALL clause in Oracle

How to find Oracle Database

Ascii Chart Oracle

For loop Oracle

While loop Oracle

Goto statement Oracle

Oracle loop

Ceil function Oracle

Floor function Oracle

Trunc Function (Number) Oracle

Sign function Oracle

Round function (Number) Oracle

Difference between Trunc and Round functions Oracle

Power function Oracle

Numeric Functions Oracle

SQRT function Oracle

Greatest and Least function Oracle

dbms_output Oracle

Simple debugging tool Oracle

Difference between DELETE and TRUNCATE in Oracle

Truncate command Oracle

Latest version of Oracle database – Oracle 12c

Replace function Oracle

Merge Oracle

Translate function Oracle

Difference between replace and translate

Single quote manipulation Oracle

FIRST_VALUE and LAST_VALUE Oracle

TO_CHAR function Oracle

SOUNDEX function Oracle

BITAND function Oracle

Oracle 12c new features

Polymorphism in Oracle

LEAD function Oracle

LAG function Oracle

Julian date Oracle

5 ways to delete duplicate records Oracle

Oracle Cursor basics

Oracle Cursor examples

PRAGMA RESTRICT_REFERENCES Oracle

Oracle Constraints

Oracle Constraints Examples

Joins Oracle

Triggers in Oracle

Bind variables Oracle

Ref Cursors Oracle

Ref Cursors Examples

5 different ways to test Oracle Ref Cursor results

Change password Oracle

What is High Water Mark in Oracle

DDL Triggers Oracle

PLJSON – JSON extension for PL/SQL

5 different ways to load flat file into Oracle table

10 must-know Oracle Interview questions

TO_DATE Oracle

sys_context Function Oracle and its usage

Difference between rank and dense_rank Oracle

What is the use of ROW_NUMBER in SQL

Rownum and order by in oracle

5 different ways to find TOP N queries Oracle

How to reset password for a locked or expired User Account

5 common mistakes Java Developers make when writing SQL

Call Oracle Stored procedure from Shell Script (OUT)

Call Oracle Stored procedure from Shell Script (IN)

How to design a database table

General Articles

Why should I learn SQL

What is ANSI SQL

Introduction – DBMS and RDBMS

Difference between DBMS and RDBMS

Database transaction and ACID properties

TIOBE Index for May 2012

TIOBE index for August 2022

32 bit or 64 bit

Notepad++ – Tips and Tricks

How to design a database table

Python

Analog Clock in Python

Daily backup script in Python

Ubuntu

Install R on Ubuntu

Installing Oracle 11g on Ubuntu

Install Notepad++ in Ubuntu 12.04

Ubuntu 12.10 New Features

Install Google Earth in Ubuntu 12.04 – 3 Steps

Memory test for Browsers in Ubuntu 12.04

Notepad++ tips and tricks

MySQL

Install LAMP on Ubuntu Desktop

MySQL SUBSTR function

Login mysql command line