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
- 4090 Views
- IAS, I also Faced
- E-Mail Answers
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 different types of keys?
How do you remove duplicates without using distinct in sql?
How do I edit a trigger in sql developer?
How can we implement rollback or commit statement in a trigger?
What is the difference between truncate and drop statements?
How do I create a memory optimized filegroup?
Is it possible to read/write files to-and-from PL/SQL?
what is query cache in mysql? : Sql dba
define different types of trigger. : Sql dba
What is the difference between functions, procedures, and packages in pl/sql?
What is the size of partition table?
What is the difference between rename and alias?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
