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
- 3929 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 |
How will we see framework of a table?
What is $$ in sql?
Why stored procedures are faster than query?
What is clustered index sql?
what is a stored procedure? : Sql dba
what are aggregate and scalar functions? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
how to extract a unit value from a date and time? : Sql dba
What is meant by temporal data?
What does desc stand for?
What are the types of optimization?
what is not null constraint? : Sql dba
-
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)
