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 clause? : Sql dba

1056

---

What are the different types of database management systems?

995

---

How many functions are there in sql?

1005

---

what are all the different types of indexes? : Sql dba

1043

---

What are system versioned tables?

1018

---

How do you change a value in sql?

1008

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1116

---

What is a temporal table?

923

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1206

---

What are stored procedures used for?

997

---

Why we use join in sql?

956

---

What are records give examples?

999

---

Which one is better sql or oracle?

962

---

how to escape special characters in sql statements? : Sql dba

1030

---

what is a tablespace? : Sql dba

1046

---