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 6001Post 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)
Explain the call transaction method? : abap bdc
i have a interlock pavement work.i need to compact about 2000 sq metres of sub base grade c of thickness 15 cm.what is the amount of water required for compaction ??
Explain what is balance sheet?
Which instutute is offering course for rhino jain slee
Can you explain what is dcom?
What is the reason behind Transformation being a lazy operation in Apache Spark RDD? How is it useful?
What is the picture clause of null indicator variable?
What is the meaning of term “flavor” in openstack?
How to concatenate strings with perl?
What are the various types of reports available in salesforce?
why d.c produces corrosion
How do I run javascript in chrome?
Android mapactivity is?
Explain about the
What is the shortcut key to open ms word?
