Question.40 Display the name,job of the employees and display Executive if the job is Clerk , RM if the job is Manager else display the job. Answer: SELECT ename,job, DECODE(job, ‘CLERK’, ‘EXECUTIVE’, ‘MANAGER’, ‘RM’, job) FROM emp; Question.41 To display employee name, department name and department number for all employees…
Question. 20 To display the number of employees working with the company. Answer: SQL>SELECT COUNT(*) FROM emp; Question.21 To display the total salaries payable to employees. Answer: SQL>SELECT SUM(sal) FROM emp; Get A live Demo Oracle Online Course
Emp Table: EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH CLERK 7902 17-Dec-95 800 20 7499 ASHA SALESMAN 7698 20-Feb-95 1600 300 30 7521 WASIM SALESMAN 7698 22-Feb-95 1250 500 30 7566 RAJA MANAGER 7839 2-Apr-95 2975 20 7654 MARIA SALESMAN 7698 28-Sep-95 1250 1400 30 7698 BILL..
Question.1 What is a database? Answer: Database offer a single point of mechanism for storing and retrieving information with the help of tables. Table is made up of columns and rows where each column stores specific attribute and each row displays a value for the corresponding attribute. It is a..
Question.1 What is Consistent Backup? Answer: A Consistent backup is one in which the files being backed up contain all changes upto the same system change number (SCN). Question.2 What is fractured Block? Answer: Because the database continues writing to the file during an online backup, there is the possibility..