My Oracle Support Banner

How To Extract The Information Needed From the Database on a Custom Object (Doc ID 2242344.1)

Last updated on MAY 20, 2021

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


 This Document will show you how to retrieve the information nedded when making SQL Predicates on Custom Objects.

You will learn the needed SQL Queries  to find out where custom fields and custom objects are stored in the database, tables and columns. 

This Document will not teach you how to build SQL Predicates but how to get all the info you need form the database regarding custom object


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
  1 - Find out in what table is a custom object been stored.
 2 - Find out in what columns are custom fields that are on a custom object
 3 - See Details of the Custom Object 
 4 - See the records in the custom object

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.