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!

Default Date Column in Create Table

Orcl ApexAug 25 2017 — edited Aug 25 2017

Hi All,

In many of our custom tables we use to have creation date and last update date columns. These columns are populated by insert statements and update statements.

Is there any way to populate the date columns automatically may be while creating table can we put something to populate these dates automatically.

I mean populate creation date when a new row inserted and populate last update date column when same row is updated again.

This post has been answered by Paulzip on Aug 25 2017
Jump to Answer

Comments

Shay Shmeltzer-Oracle
Did you actually tried the JDeveloper support for this?
Any specific component that causes you a problem when running on the palm?
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 22 2017
Added on Aug 25 2017
6 comments
57,726 views