I am having a problem with timestamp value.
There is a table say
A having
create table A
(
Name varchar2(10),
tstamp timestamp(2) default systimestamp(2)
);

Now During Inserts

insert into A(name) values ('test');

gets the current time stamp.
But when

Update A set name='TEST' where name='test';
Here Starts the problem, i need to get the current timestamp of the update operation performed on the table.
Its same usage like MySQL
timestamp - no need to explicitly define. It executes and updates timestamp imlicitly.

NOTE - I know that it can easily implemented using trigger but requirement dont allow us to use it.
I have tried using following (applicable In MYSQL not heree - giving to make the situation more clear)
`Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP