How to easy duplicate records
Hi, maybe someone has a good idea how to make an easy (short) duplicating of a record
with huge number of fields, giving it a new id.
Example: I don't want (and sometimes it is very inconvinient) to run
Insert Into my_tab (id, a, b, c, d, ... )
(Select 2, a, b, c, d, ...
From my_tab
Where id = 1)
because of huge number of fields.
Also, I can't do Insert + Update because "id" is unique.
Thanks in advance,
G.R.