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 are the different dcl commands in sql?

1120

---

Is primary key is clustered index?

986

---

What is application trigger?

977

---

How do you update a value in sql?

1022

---

What is left inner join in sql?

1024

---

What is the need of merge statement?

1012

---

How do I truncate a sql log file?

1053

---

What is the difference between local variables and global variables?

1109

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1569

---

What are all types of user defined functions?

1056

---

what does myisamchk do? : Sql dba

1002

---

What are the different tcl commands in sql?

1152

---

What is an implicit commit?

1038

---

Is trigger a stored procedure?

922

---

What are properties of the transaction?

991

---