RAISE statement in PostgreSQL is used to report messages and raise errors. PostgreSQL provides level option to specify with RAISE that specifies the severity of the statement. Possible levels with…
A cloud database is a database service built and accessed through a cloud platform. In simple terms, cloud databases are databases hosted in the cloud vendor's environment and you access…
Single QuoteDouble QuoteUsed to declare string and date literals.e.g. SELECT 'This is your string' test_str FROM DUAL;SELECT '31-DEC-2019' test_date FROM DUAL;Used to declare identifiers like table name or column name.e.g.…
Data is the ultimate asset in today's world. Data is the raw facts and statistics collected during any operation. Types of Data? Structured: Data is categorized as structured or…
Gone are the days when an RDBMS (Relational Database Management System) was the appropriate solution for every database need. Why? Let’s discuss two scenarios in this post. Consider the “Three…
Every PostgreSQL function has some special attributes which greatly determines its behavior. Every function in PostgreSQL has a volatility classification, with the possibility of being VOLATILE, STABLE, or IMMUTABLE. VOLATILE is the default if…
When it comes to choosing a database the biggest decisions is picking a relational (SQL) or non-relational (NoSQL) data structure. While both the databases are viable options still there are…
BigData and NoSQL are the choice for database solutions nowadays, but that does not mean the crucial features of RDBMS will die. Since 90% of the world data produced in…
Part of me wonders why we focus our trend and market predictions at the beginning and end of each year, when we all know these changes are fluid, and don’t…