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 […]
Auto Increment Column – Sequence as Default Value in Oracle
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. […]
MySQL queries examples with answers
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 […]
What is Oracle Autonomous Database
Oracle Autonomous Database An autonomous database is a cloud database that uses ML to automate database optimization, security, backup, updates, and other routine administrative tasks traditionally performed by database administrators. Unlike traditional databases, autonomous databases perform all of these tasks but do not require human intervention. user can define backup buckets and staging buckets (storage), […]
How to find ad and txk patch level
We can find the various patch level using the table ad_trackable_entities in Oracle Apps R12.2. In this post, we will see How to find ad and txk patch level, how to check delta level in r12, how to check fwk in r12.2 Here is the definition of the Table ad_trackable_entities How to find ad and […]
Script to check locks in oracle database
In this post, we will see Script to check locks in oracle database, how to check locks in oracle, how to check lock on table in oracle Locks is a process in the Oracle database through which it maintains consistency and concurrency. So they keep coming and going. We generally don’t need to worry about […]