Oracle query to create 50 copies of single row into the same table with different Student_id
posted 2 days ago
I have one table called 'Student' and having 30 columns including student_id as primary key.
Now i have one entry already there in table with 'student_id' = 1. (defines one student data)
Now i want to create one sql query to copy all the data same from the row, but with different student_id as it is primary key defined there.
(Note: it will create 50 different students entry into table automatically with the same data)