Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
select empno,ename from emp where deptno in(
select deptno from dept where dept.deptno=emp.deptno)
when inner subquery has an reference to outer query then
this is know as Correlated sub-query.
| Is This Answer Correct ? | 107 Yes | 23 No |
Post New Answer View All Answers
List out the acid properties and explain?
Can we use view in stored procedure?
What is application trigger?
Does sql between include endpoints?
What is function and procedure?
How can we avoid duplicating records in a query?
What is java sql connection?
What are pl/sql packages?
discuss about myisam index statistics collection. : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is an exception in pl/sql?
Why is the cursor important?
What does select top 1 do in sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
