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
- 3924 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 |
Is left join same as join?
What does fetching a cursor do?
Does sql support programming?
How would you reference column values before and after you have inserted and deleted triggers?
What is parameter substitution in sql?
what is organisational index?
What is a null value?
What are the disadvantages of not performing database normalization?
What is ROWID?
Explain alias in sql?
Is join and inner join the same?
What is the purpose of cursors in pl/sql?
-
Oracle (3259) - 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)
