This SQL tutorial provides explanations, examples for Update statement in oracle Update statement in oracle is used to update the existing rows in the table. It is a DML statement. DML stand data manipulation language. We can use this statement to update specific rows ,set of rows or all rows in the table. Syntax is […]
How to update table in oracle Read More »
We will start with an introduction to the primary key in oracle and then we will dive into various queries on it. Introduction to Primary Key A primary key is a column or set of columns in the table which uniquely identifies a row in the table. Properties of Primary key You cannot have duplicate
Top Queries on Primary Key in Oracle with Examples Read More »
FND_LOBS is one of the big and important table in Oracle Apps . Lets see various important things about this table What is stored in FND_LOBS? FND_LOBS stores information about all LOBs managed by the Generic File Manager (GFM). Each row includes the file identifier, name, content-type, and actual data. Each row also includes the
Things You must know about FND_LOBS Table in Oracle Apps Read More »
What is attachments in Oracle Applications The attachments feature enables users to link unstructured data, such as images, word processing documents, spreadsheets, or text to their application data. For example, users can link images to items or video to operations as operation instructions. Attachment information can flow through your entire application. For example, if you
Attachments in Oracle Applications R12 Read More »
RMAN Recovery catalog is a very important registry. Control file registry get rotated after some time so you lost many backup information. By storing backup information in recovery catalog ,you get rid of this problem Also it provides a central repository where you can find all the backup information. Here are the steps on How to
How to create RMAN recovery catalog and register database in catalog Read More »
Here in this post, we will be looking at how to upgrade an existing 12c database to 19c Database. Here is the high-level summary of the steps Installation of Oracle 19c Oracle Home Preupgrade Checks 19c Upgrade PostUpgrade Checks Installation of Oracle 19c Oracle Home You can take a look at the below article for
Oracle 19c upgrade step by step Read More »
