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 5951Post New Oracle Programming Languages AllOther Interview Questions
- Oracle C Interview Questions (21)
- Oracle OOPS Interview Questions (2)
- Oracle C++ General Interview Questions (3)
- Oracle PHP Interview Questions (2) Oracle Programming Languages AllOther Interview Questions (4)
- Oracle CGI Perl Interview Questions (2)
- Oracle JavaScript Interview Questions (1)
- Oracle VB Script Interview Questions (1)
- Oracle Networking Administration Interview Questions (1)
- Oracle Oracle General Interview Questions (45)
- Oracle Oracle Architecture Interview Questions (1)
- Oracle Oracle Forms Reports Interview Questions (6)
- Oracle Oracle AllOther Interview Questions (15)
- Oracle SQL Server Interview Questions (11)
- Oracle Sybase Interview Questions (1)
- Oracle DB Administration Interview Questions (33)
- Oracle SQL PLSQL Interview Questions (40)
- Oracle Database Management Interview Questions (5)
- Oracle Linux Commands Interview Questions (6)
- Oracle Linux General Interview Questions (2)
- Oracle Linux AllOther Interview Questions (4)
- Oracle Unix Commands Interview Questions (2)
- Oracle Unix AllOther Interview Questions (1)
- Oracle Solaris General Interview Questions (2)
- Oracle Operating Systems General Concepts Interview Questions (2)
- Oracle Load Runner Interview Questions (1)
- Oracle QTP Interview Questions (18)
- Oracle Test Director Interview Questions (1)
- Oracle Selenium Interview Questions (1)
- Oracle Automation Testing AllOther Interview Questions (1)
- Oracle Manual Testing Interview Questions (29)
- Oracle QA Concepts Interview Questions (13)
- Oracle Testing AllOther Interview Questions (5)
- Oracle COBOL Interview Questions (2)
- Oracle Core Java Interview Questions (16)
- Oracle Advanced Java Interview Questions (2)
- Oracle Struts Interview Questions (1)
- Oracle J2EE Interview Questions (6)
- Oracle Weblogic Interview Questions (6)
- Oracle Oracle GoldenGate Interview Questions (53)
- Oracle Middleware AllOther Interview Questions (1)
- Oracle Business Objects Interview Questions (6)
- Oracle Cognos Interview Questions (2)
- Oracle Informatica Interview Questions (4)
- Oracle Data Stage Interview Questions (1)
- Oracle SAS Interview Questions (34)
- Oracle Data Warehouse General Interview Questions (3)
- Oracle HR Questions Interview Questions (2)
- Oracle UML Interview Questions (1)
- Oracle Project Planning Interview Questions (1)
- Oracle SAP Basis Interview Questions (1)
- Oracle SAP FI-CO (Financial Accounting & Controlling) Interview Questions (1)
- Oracle SAP SRM (Supplier Relationship Management) Interview Questions (1)
- Oracle PeopleSoft Administration Interview Questions (1)
- Oracle Siebel Interview Questions (3)
- Oracle ERP General Interview Questions (2)
- Oracle Oracle Apps Technical Interview Questions (32)
- Oracle Oracle Apps Financial Interview Questions (60)
- Oracle Oracle Apps Manufacturing Interview Questions (3)
- Oracle Oracle Apps HRMS Interview Questions (35)
- Oracle Oracle Apps CRM Interview Questions (1)
- Oracle Oracle Apps SCM Interview Questions (7)
- Oracle Oracle Service Contracts Interview Questions (1)
- Oracle Oracle Apps AllOther Interview Questions (1)
- Oracle 3D Animation Interview Questions (1)
- Oracle Image Processing General Interview Questions (1)
- Oracle Zoology Interview Questions (3)
- Oracle Civil Engineering Interview Questions (1)
- Oracle Mechanical Engineering Interview Questions (1)
- Oracle Electrical Engineering Interview Questions (2)
- Oracle Electronics Communications Interview Questions (3)
- Oracle Engineering AllOther Interview Questions (4)
- Oracle Marketing Sales Interview Questions (5)
- Oracle Banking Finance Interview Questions (2)
- Oracle Human Resources Interview Questions (2)
- Oracle Non Technical Interview Questions (3)
- Oracle Accounting General Interview Questions (1)
- Oracle Oracle General Ledger Interview Questions (40)
- Oracle Accounting AllOther Interview Questions (4)
- Oracle APPSC AllOther Interview Questions (3)
- Oracle Everything Else AllOther Interview Questions (1)
- Oracle General Aptitude Interview Questions (8)
- Oracle Puzzles Interview Questions (9)
- Oracle Placement Papers Interview Questions (2)
- Oracle CISA Certification Interview Questions (2)
- Oracle Oracle Certifications Interview Questions (12)
- Oracle Australia Visa Interview Questions (1)
- Oracle C Code Interview Questions (2)
- Oracle J2SE Code Interview Questions (1)
- Oracle Programming Code AllOther Interview Questions (1)
- Oracle CAT Interview Questions (1)
- Oracle Oracle Errors Interview Questions (17)
What does r mean linux?
Draw the circuits of cb, ce and cc configurations using npn transistor.
How does insertion sort work?
What are the advantages of attribute view? : hana administration
What is gridview in asp.net?
Why occurs cannot be used in 01 level in COBOL?
What's your approach to fetch static data in your windows form application?
What are immunoglobulins? Explain its structure.
What json framework supported by ios?
Describe Briefly The Various Methods Of Concrete Curing?
Hi I'm looking for two SAP Project Manager (one specialized in MM/PP, one in FI) for Automotive, based in Compiègne (Oise, France). Should somebody give me an idea to find these persons ? thanks a lot !
What does break do in loop?
What is fineness modulus ? and its sieve # ?
What are the objects of ado.net?
What is multilevel inheritance?
