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
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 the various levels of constraints?
ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.
How does rowid help in running a query faster?
Can we use having without group by in sql?
Why are aggregate functions called so?
How do you use a while loop in pl sql?
How do we tune the code?
What does truncate mean in sql?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
What is materialized view. What are different methods of refresh?
how to select unique records from a table? : Sql dba