Skip to Main Content

SQL Developer for VS Code

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!

Valid time dimension support in tables?

AndyH17 hours ago

Version 25.4

There doesn't seem to be an easy way of editing/viewing valid time dimensions e.g.

CREATE TABLE wibble
( ID RAW(16) NOT NULL ENABLE
"EFFECTIVE_FROM" TIMESTAMP (6) WITH LOCAL TIME ZONE DEFAULT ON NULL current_timestamp NOT NULL ENABLE,
"EFFECTIVE_TO" TIMESTAMP (6) WITH LOCAL TIME ZONE);
ALTER TABLE wibble ADD PERIOD FOR CURRENT_RECORD(EFFECTIVE_FROM,EFFECTIVE_TO) ;
Comments
Post Details
Added 17 hours ago
1 comment
21 views