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
3921 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 is anonymous block in sql?

1070

What are the constraints available in sql?

992

What is the best sql course?

928

what are the authentication modes in sql server? How can it be changed? : Sql dba

1313

What is self-join and what is the requirement of self-join?

1088

how to convert dates to character strings? : Sql dba

1067

explain access control lists. : Sql dba

945

What is serial sql?

915

What is pl sql in oracle?

987

What is difference between procedure and trigger?

914

Is a secondary key the same as a foreign key?

952

Can we use join in subquery?

1020

What is sql table?

902

Can we use commit inside a trigger?

1022

What is primary key and foreign key?

914