I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p
if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately
Can anyone help on this?
Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
i am an comp science engineering graduate planning to do
ORACLE certification in PLSQL 9i. just wanted to know whats
the possibility getting job is their openings???? is it
worth doin that course n certification
what is the difference between varray and table data
type..please expalain with some examples...
under what situation you will go for varray..instead of
index by table...
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:
WHERE gc_area_tec.id_skill_type (+) =
AND gc_technology.id_area_tec (+) =
order by gc_skill_type.skill_type asc, gc_area_tec.area asc,
what is the use of anchoring object? what r the difference
between anchoring object & enclosing object? can any one
tell me all the details?
column A column b | output
10 7 | 10
5 8 | 8
7 -9 | 7
3 5 | 5
0 6 | 6
Write a sql query to print such output.
how will i became good database developer?
What are wait events. Describe the wait event tables.
I have a tablle like this:
I Want below o/p:
Please any one can you have any ideas share me.
I have urgent requirement.