There are 2 tables: EMP : EmpId, Ename, Sal, DeptId DEPT : DeptId, Dname Write a query to find out emp names and their department names. if any emp has null in Deptid the it shows ?No Department?. Write a query to find out those department names which has no employee. Write a query to find out those employees whose salary is greater than their department?s average salary.
1 6460Post New Oracle Programming Languages AllOther Interview Questions
Explain how to create custom 404 page in codeigniter?
Explain why nitrogen cannot form penta halides?
Is it necessary to learn hadoop for spark?
How do I clear the screen in sql plus?
What is model.attributes ?
which are the key concepts of entity data model?
Can we save images in a database and if yes, how?
Please can anybody explain what exactly "the project architecture" means???
What type of errors can be occurred in php?
Why cursor variables are easier to use than cursors?
Explain how do I get deterministic finalization in c#?
What are the file systems and volume management techniques used in oracle rac?
What problems might be encountered if there were no accounting standards?
Are the grain boundaries a continuation of regular lattice structure from one grain to another? Explain.
What is test pyramid? Explain with an example?