Hi Gurus,
I would like to build a logic where I can generate auto number for one of the field..
I have development below code WNI and even tried Pre Insert trigger(The moment when I click on new row a number should get generate)
But as per the below logic ...same(Duplicate) number getting generated ,if I save on each row a new number getting.
DECLARE
new_attribute_id number :=1;
begin
select nvl(max(new_attribute_id),0)+1 into blk.attribute_id from dual;
end;
regards
Srini