Interested to Buy Any Domain ? << Click Here >> for more details...
Q1.all the depts which has more then 10 empls? Q2.all the
dept which does not have any emply? Q3 all the emp which
does not have any dept? Q4 get all the emply detais with
the dept details it dept is exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?
- 2 Answers
- 5294 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramkiran
select emp.deptno,emp.ename,dept.deptno,dept.dname from
emp,dept
where emp.deptno(+) = dept.deptno
order by 1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is sp_pkeys? : Transact sql
What does t sql mean?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is data type in sql?
How do you optimize a query?
How does index help in query performance?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
How does pl sql work?
which operator is used in query for pattern matching? : Sql dba
Which is faster truncate or drop?
What normalization means?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What are properties of the transaction?
How do I get sql certification?
