Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4091 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
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
what is schema? : Sql dba
List the various privileges that a user can grant to another user?
How can you create an empty table from an existing table?
what is blob? : Sql dba
Is sql a backend?
what are rollup and cube in t-sql? : Transact sql
What is cursor and why it is required?
What is out parameter used for eventhough return statement can also be used in pl/sql?
what is subquery? : Sql dba
Mention what does plv msg allows you to do?
What is restrict in sql?
What is data abstraction in sql?
how to drop an existing table in mysql? : Sql dba
Can we join more than 2 tables in sql?
