how to delete duplicate rows from a join tables(I have three tables on that joi

how to delete duplicate rows from a join tables(I have three
tables on that join)
how do you know which join is need to be used?

The select statement I have is:

SELECT gc_skill_type.skill_type,
gc_area_tec.area,
gc_technology.technology,
gc_technology.id_technology,
gc_area_tec.id_area_tec
FROM gc_skill_type,
gc_area_tec,
gc_technology
WHERE gc_area_tec.id_skill_type (+) =
gc_skill_type.id_skill_type
AND gc_technology.id_area_tec (+) =
gc_area_tec.id_area_tec
order by gc_skill_type.skill_type asc, gc_area_tec.area asc,
gc_technology.technology asc

Question Posted / betasilva

1 Answers
3216 Views
IAS, I also Faced
E-Mail Answers

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know ..

Answer / kumar

Seems to be an Inline View (Read Only). We cannot perform
dml operations on this query. Creating a complex with this
query may solve the issue.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers Tech Mahindra,

What is varchar example?

0 Answers

What is a temp table?

0 Answers

Does a primary key have to be a number?

0 Answers

what is a constraint? : Sql dba

0 Answers

what is the difference between nested subquery and correlated subquery?

0 Answers

What is sql clause?