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
- 4835 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
Which is better varchar or nvarchar?
How many joins can you have in sql?
Can you join a table to itself?
How to execute a stored procedure?
what is the use of double ampersand (&&) in sql queries?
What are synonyms in sql?
What are instead of triggers?
Which is faster count (*) or count 1?
What are the parameter modes supported by pl/sql?
write an sql query to find names of employee start with 'a'? : Sql dba
what is cursor. write example of it. What are the attributes of cursor.
How do you modify a column in sql?
how many groups of data types? : Sql dba
How to know the last executed procedure?
how to see the create table statement of an existing table? : Sql dba
