Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

delete duplicate rows without pseudo columns like rowid

ora_1978May 26 2022 — edited May 26 2022

create table dept (dno number, dname varchar2(100));
insert into dept values (10, 'IT');
insert into dept values (10, 'IT');
COMMIT;

AFTER DELETION UPON EXECUTING THE QUERY TEH RESULT SHOULD BE

SELECT * FROM DEPT;
10, IT

Comments
Post Details
Added on May 26 2022
19 comments
2,564 views