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
3928 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 a pl/sql block?

1118

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

946

What is a constraint?

962

How can we find duplicate records in a table?

894

What is using in sql?

1019

What is nested table in pl sql?

1007

What is sql in oracle?

1004

Is progress software supports to ( pl/sql )?

973

what is the use of set statement in tsql? : Transact sql

945

What is sql not null constraint?

983

List the different type of joins?

1003

what is the difference between undefined value and null value? : Sql dba

1041

What is the use of stored procedures?

977

Can we create table inside stored procedure?

907

What is the use of <> sql?

933