You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Meaning of Oracle table name with and without "_" at its end?

Accepted answer
22
Views
2
Comments
edited Jun 11, 2020 3:36AM in General Transactional Reporting (OTBI) 2 comments

Summary

What is the difference between Oracle tables named with and without "_" at the end?

Content

Hello Oracle Community,

1) What's the difference between Oracle tables that are different only by an underscore "_" written at the end of the table name? 

Ex. Table "EGP_SYSTEM_ITEMS_B" and Table "EGP_SYSTEM_ITEMS_B_"?
• Link to information about the above 2 tables:
https://docs.oracle.com/cd/E83857_01/saas/supply-chain-management/r13-update17d/oedsc/EGP_SYSTEM_ITEMS_B-tbl.html

2) Furthermore, do you know which columns and tables are the descriptions to Attribute entries usually located at?  In particular the descriptions to Attribute4 and Attribute5 in the table EGP_SYSTEM_ITEMS_B.  I understand the description entries' location could be company specific but I am wondering whether there are columns where the attribute descriptions are usually located at.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!