We will be discussing MySQL COALESCE and NULLIF Function in this post. We will also be showing MySQL COALESCE examples and NULLIF MySQL Function example MySQL COALESCE Function COALESCE in MySQL is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent […]
MySQL COALESCE and NULLIF Function Read More »
Auto Increment Column is a quite common requirement in the coding. Here are some of the ways to get that in Oracle Auto increment in oracle This feature( Oracle Auto Increment Column – Sequence as Default Value) is not present in the Oracle database so far. But with 12c, oracle is able to provide that.
Auto Increment Column – Sequence as Default Value in Oracle Read More »
Useful and common MySQL queries examples with answers for the developer and DBA’s How to create a MySQL database mysql> create database techdb;mysql> use techdb; How to create table in mysql database? Here is the example for table creation in the MySQL database(1) We need to first get into the database use techdb; (2) Create
MySQL queries examples with answers Read More »
This post talks about What is Flashback Database in Oracle, How a flashback database works,How to configure flashback database What is Flashback Database A new feature from 10.1 onwards, Uses past block images to back out changes to an oracle database During normal database operation, Oracle occasionally logs past block images in flashback logs Flashback
Oracle Flashback Database explained and limitation Read More »
TDE stands for Transparent Data Encryption. It was initially released in Oracle 10gR1 where it gave the capability to encrypt the column in the table. With 11gR1, we can now encrypt both the tablespace and individual table columns using TDE. This article, we will see the step by step process for TDE encryption in oracle
TDE encryption oracle 11g step by step Read More »
If you are deleting rows from a table that is referenced by the foreign key of another table, then you will get integrity constraints errors(ORA-02292). This can be avoided by using DELETE CASCADE in Oracle Let’s take an example. In this, we will first create the sample tables, then insert rows and then try for
Oracle delete cascade: ORA-02292 Integrity Constraints error Read More »
