Blogs
SQL DDL Commands
Structured Query Language (SQL) is known as the database language. SQL commands are instructions, coded into...
Pattern Joins in Oracle Using Like Operator
The Like operator is used to search the pattern in one table. Similarly, we can use the like operator along...
Understanding Amazon DynamoDB
Introduction Amazon DynamoDB is one of the non-relational and No-SQL database products from AWS. It supports...
Understanding Amazon RDS
Introduction: Amazon RDS is relational database service from AWS. It is a DBaaS (DataBase as a Service)...
Post Clone Login Issues on Oracle Apps R12.2.4
Non-PROD instance clone has been completed successfully from PROD instance and no issues were encountered...
Tableau Filters
The filters can be applied in a worksheet to restrict the number of records present in a...
Oracle Multitenant Architecture
Introduction: From Oracle Database 12c release, Oracle introduced multitenant architecture. With this...
Oracle Data Guard and Active Data Guard
Introduction: To ensure data protection, high availability and disaster recovery for enterprise data, Oracle...
Subversion
Introduction: Subversion (SVN) is a centralized SCM (Software Configuration Management) implementation. It...
QlikView Server License Update
1. Backup Plan before license Update Before going ahead for license update activity, we need to take the...
Difference between Rank and Dense_Rank Functions and Nth Highest salary
Rank (): RANK function is used to rank the repeating values in a manner such that similar values are ranked...
Datatypes and operators in Redshift
Redshift query basics: The maximum size for a single Amazon Redshift SQL statement is 16 MB Some Amazon...