With List and Range Partitions, you know exactly which data...
Read More
RECENT POSTS ON DATABASES
Escape Single Quotes in Oracle SQL
Single quotes are used in databases to represent string and...
Read MoreMigrating Cursors from Oracle to PostgreSQL
Cursor is a mechanism by which you can assign a...
Read MoreDifference between single quote and double quote in Oracle SQL
In this article, you will understand when and where to...
Read More
OUR DOCUMENT LIBRARY
Oracle to PostgreSQL Migration
Our documentation is a guide to expand your PostgreSQL competency if you come from an Oracle database background and also helpful to build Oracle comparable functionality in PostgreSQL. The chapters in this documentation are very useful for developers who migrate Oracle database objects to PostgreSQL. Not all Oracle features have direct and fully compatible equivalents […]Read More
SQL using PostgreSQL 13
PostgreSQL is one of the World’s Most Advanced Open Source Relational Database. It extends the SQL language combined with many features that safely store and scale the most complicated data workloads. PostgreSQL tries to conform with the SQL standard where such conformance does not contradict traditional features or could lead to poor architectural decisions. Many of the […]Read More
Oracle 19c SQL
Oracle is the most widely used Database Management System in current world. Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation. Happy Reading and Learning Through Examples!
Read MoreFundamentals of Database programming using Python
This course provides basics on minimum requirements to connect to a database from Python. We have taken Python 3 for this course. Python supports various databases like MySQL, Oracle, Sybase, PostgreSQL, etc. This course will introduce you to the basics of how to connect to different databases and performing database operations using Python.
Read MoreRDBMS
RDBMS stands for Relational Database Management System. RDBMS is the basis for evolution of all the modern relational databases. Our documentation is built keeping industry in mind. Articles and examples are based on practical use cases and will guide you from a level of zero to the extent you are confident on the subject. Our […]Read More
Oracle SQL Interview Questions
Most Frequently asked Oracle database SQL questions and answers This article covers a list of all the most important and commonly asked “Oracle Database SQL” interview questions and answers, which will help you to crack any interview. Most Popular Oracle SQL Interview Questions and Answers Q1 : What is Tablespace in Oracle? Ans: Tablespaces are […]Read More
Oracle PL/SQL Trigger Interview Questions
Most Popular PL/SQL Trigger Interview Questions and Answers Most job interviews involve an exchange of common question patterns. Therefore it is always good to get prepared before an interview and answer at least some of them with confidence. Read top 50+ questions and answers on Triggers in Oracle. Q1 : What is a Trigger? Ans: […]Read More