Seems to be an Inline View (Read Only). We cannot perform dml operations o

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 / kumar

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

what are aggregate and scalar functions? : Sql dba

1057

Can sql developer connect to db2?

1048

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

what is the difference between char_length and length? : Sql dba

1044

is it possible to pass an object or table to a procedure as an argument?

1135

Can delete statement be rollbacked?

984

What is a natural join sql?

973

What is a recursive join sql?

1072

What is cursor explain with example?

985

What is a full join sql?

1056

Why use truncate instead of delete?

1016

Is sql workbench free?

995

What are database links used for?

1047

What is the best free sql database?

1052

What is multiple partition?

967