SQL Language (MOSC)

MOSC Banner

How to easy duplicate records

edited Jan 7, 2016 9:17AM in SQL Language (MOSC) 5 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center