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
- 4003 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 is rollback? : Sql dba
What is trigger and stored procedure in sql?
What is the use of index in sql?
How do you update a table in sql?
What is the difference between inner join and left join?
What is a delimiter in sas?
How many sql statements are used? Define them.
Explian rowid, rownum? What are the psoducolumns we have?
How many clustered indexes can you have?
Is record in pl sql?
what is self join and what is the requirement of self join? : Sql dba
What are advantages of Stored Procedures?
-
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)
