1. Display the dept information from department table. Select * from dept; 2. Display the details of all employees Select * from emp; 3. Display the name and job for all employees Select ename ,job from emp; 4. Display name and salary for all employees. Select ename , sal from emp; 5. Display employee number and total salary for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees. Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10 Select ename from emp where deptno=10; 8. Display the names of all employees working as clerks and drawing a salary more than 3000 Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commissi...
For latest and updated 1z0-591 OBIEE certification dumps contact us at completeexamcollection@gmail.com.
ReplyDeletehi..
ReplyDeletetell me how to download informatica tool .
Hello,
ReplyDeleteCan you please share the documents for
Oracle Business Intelligence Foundation Suite 11g Essentials
Exam: 1Z0-591
My Id is-: ankupangul28@gmail.com