Techgoeasy

How to migrate the schema from one database to another database using exp/imp

Modern oracle database uses the datapump utilities. This exp/imp is for the legacy database where datapump utlities are not present Here,I will give u Detailed steps for Schema Migration using exp/imp, pipe,gz between two databases How to migrate the schema from one database to another database The below steps need to be done on the […]

How to migrate the schema from one database to another database using exp/imp Read More »

How to run sql tuning advisor for a sql _id

Oracle, Oracle Database

Many times a sql may be running long and we may need to run sql tuning advisor to get the recommendation to resolve the long running issue.In this post, we would be looking at the steps to achieve it Steps for running sql tuning advisor on the particular sql -id in the Cursor cache Create

How to run sql tuning advisor for a sql _id Read More »

JSON in Oracle database

Oracle, Oracle Sql

Lets first start with what is JSON What is JSON JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition – December 1999.

JSON in Oracle database Read More »

How to check PSU patch version in oracle

Oracle, Oracle Database

In this article, we will learn about what are PSU patches, Release update patches. How to check PSU version in the Oracle server and many more things What is a PSU patch for Oracle Home? Patch Set Updates (PSU) are the same cumulative patches that include both the security fixes and priority fixes. The key

How to check PSU patch version in oracle Read More »

How to use NVL() function in Oracle

Oracle, Oracle Sql

This Oracle SQL tutorial provides explanations, examples for NVL function in Oracle What is NVL() function in Oracle NVL function in Oracle is a nesting function that is used to substitute null values with certain values In the above syntax expr1: it is the source values or expression which may contain null. You can provide

How to use NVL() function in Oracle Read More »

Admin scripts in R12.2 Ebuisness Suite

Oracle, Oracle Ebuisness Suite

In this section, we will talk about various Oracle EBS 12.2 start-stop scripts in the latest release of Oracle Apps by Oracle Corporation. Here are the main scripts and how they are used to stop /start the application Start Scripts in R12.2 Stop Scripts in R12.2 Consolidated Scripts for Stop/Start We already know the consolidated scripts

Admin scripts in R12.2 Ebuisness Suite Read More »