Answer Posted / ramkumar v

CREATE OR REPLACE PROCEDURE DUP AS

DECLARE
TABLENAME_TMP TABLE;

CURSOR C1 IS
SELECT M.TABLE_NAME
FROM USER_TAB_COLS M
WHERE M.COLUMN_NAME LIKE 'EMPNO';

BEGIN

OPEN C1;
LOOP
FETCH C1 INTO TABLENAME_TMP;
WHEN C1%NOTFOUND THEN EXIT;

DELETE FROM TABLENAME_TMP A WHERE ROWID NOT IN
(SELECT MAX(ROWID) FROM TABLENAME_TMP B

WHERE A.EMPNO>=B.EMPNO);
ENDLOOP;
CLOSE C1;
END DUP;

what is the functionality of the function htmlentities? : Sql dba

965

---

How do I run a query in pl sql developer?

996

---

What are schema-level triggers?

1102

---

Is join same as left join?

1041

---

Why do we use partitions in sql?

1050

---

Where the sql database files are stored?

1015

---

How do I run a sql script?

1149

---

What is string data type in sql?

1144

---

How to assign sql query results to pl sql variables?

1081

---

What is keys and its types?

1075

---

how to delete an existing column in a table? : Sql dba

1005

---

what is clause? : Sql dba

1063

---

What is the difference between clustered and non-clustered index in sql?

1016

---

How is data stored in sql?

1061

---

what is not null constraint? : Sql dba

1030

---