Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can store global data in table?

YuriDeseDec 13 2017 — edited Dec 24 2017

I want to store global data about a table.

I mean "global" in the scope of the table, not outside of it.

I mean data that only requires one storage place, and not a row on the table.

For example, comments, documentation, CLOB data, code to insert/read/delete

Is possible to do it? I do not want to store this data on a table row, because it is unique data, and I do not want to store it outside the table, because there will be no way to know that the data/code is uniquely related to this table.

Ideally, I would like to access that data/code as Tablename.Data or TableName.FunctionCall, as I would do with an object on other programing languages.

This post has been answered by Mike Kutz on Dec 14 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2018
Added on Dec 13 2017
67 comments
1,600 views