Explain isolation levels. : Transact sql
What is sql*loader and what is it used for? : aql loader
What is a CTE (Common Table Expression), and how is it different from a subquery?
How to fix oracle error ora-00942: table or view does not exist
How to create a menu in sqlplus or pl/sql?
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
what is a field in a database ? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
Explain the commit statement.
What is pl sql in oracle?
What are the qualities of 2nf?
Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
what is bulk bind