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
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 |
What are the ways on commenting in a pl/sql code?
What does the acronym acid stand for in database management?
How to call shell script from pl sql procedure?
What is exception? What are the types of exceptions?
when a procedure /package is getting invalidated?
Does sql*plus also have a pl/sql engine?
What is package in pl sql?
what is the main difference between join and subqurey?
What is the difference between the conventional and direct path loader? : aql loader
What is the Diff b/w Constraints and Trigeer
What trigger means?
How many rows will return from dual table?