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
4007 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

How to process query result in pl/sql?

1120

What is the source code of a program?

1064

What does 0 mean in sql?

962

How much does sqlite cost?

1033

What is the difference between functions, procedures, and packages in pl/sql?

1040

what is 'mysqladmin' in mysql? : Sql dba

1024

Is join and inner join the same?

1000

Explain the advantages and disadvantages of stored procedure?

1140

Can function return multiple values in sql?

1049

What is full form of rtm?

1001

How to display the current date in sql?

1069

What are the advantages of sql?

1051

What are the different parts of a package?

1108

what are aggregate and scalar functions? : Sql dba

1053

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7315