Answer / ram

Guys, Please see the question again. It is related to
deleting different tables. I guess, the question is
intented to get the answer - ON DELETE CASCADE. We give
foreign constraints on tables and when the parent record is
deleted, the child records are automatically deleted when
you give command as ON DELETE CASCADE

Answer / madhu

delete from emp where emp_no in
(select emp_no from emp2 where emp.emp_no=emp2.emp_no)

Answer / 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;

Answer / khandu shinde

delete from emp where rowid not in ( select max(rowid) from
emp group by empno)

Answer / satyam kumar

Hi,

I have manipulated Khandu Shinde answer because it will
delete complete row.

delete from emp where rowid not in ( select max(rowid) from
emp group by empno having count(redundantcolumnName) > 1)

Note: work only with Oracle.

Answer / rajesh

DELETE emp WHERE ROWID NOT IN(SELECT MIN(eid)FROM emp GROUP
BY eid);

Why do we create views in sql?

0 Answers  

What is PL/SQL table ?

6 Answers  

How many subqueries can be nested in a statement?

0 Answers  

What is right join in sql?

0 Answers  

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

What is a string data type in sql?

0 Answers  

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

diff b/w function and procedure?

9 Answers   iFlex,

Can I call a procedure inside a function?

0 Answers  

What are expressions?

0 Answers