• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

MySQL COALESCE and NULLIF Function

May 1, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: mysql Tagged With: MySQL COALESCE, NULLIF Function

Auto Increment Column – Sequence as Default Value in Oracle

April 30, 2022 by techgoeasy Leave a Comment

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. […]

Filed Under: Oracle, Oracle Sql Tagged With: Auto Increment Column - Sequence as Default Value in Oracle and mysql

MySQL queries examples with answers

April 30, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: mysql

What is Oracle Autonomous Database

April 28, 2022 by techgoeasy Leave a Comment

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), […]

Filed Under: Oracle, Oracle cloud

How to find ad and txk patch level

April 26, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Ebuisness Suite

Script to check locks in oracle database

April 26, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

  • « Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • …
  • Page 107
  • Next Page »

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to start/stop Node manager and Managed server in Weblogic
  • Weblogic Administration Console
  • How to enable SSL in Oracle Weblogic
  • How to stop-start WebLogic AdministrationServer
  • ORA-28007: the password cannot be reused

Copyright © 2022 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us