(1) Create a table Emp having following fields. Empno, Ename. Dno, Job, Salary, Age, Manager. Create foreign key on Dno

[answerhappygod]

1 Create A Table Emp Having Following Fields Empno Ename Dno Job Salary Age Manager Create Foreign Key On Dno 1 (31.47 KiB) Viewed 43 times

(1) Create a table Emp having following fields. Empno, Ename. Dno, Job, Salary, Age, Manager. Create foreign key on Dno references Dno of dept table. (11) Create a table dept having following fields. Dno. Dname. Create primary key on Dno. Use appropriate data types to describe each field. 1. How many different departments are there in the employee table? 2. Count the name and average salary of each department. 3. Find the employees having salary more than 20000 per month divide by 300 and make it as whole number. 4. Write a query which will display employee name and their job with in parentheses immediately after the name. 5. Display the Ename. Dno where each column value should be displayed 10 character, if the value is less than of 20 character right pad Ename left pad Dno with '&' and left pad salary with @'. Write PL/SQL block for the following: 1) Delete venue with least capacity by taking existing input at run time. 2) To find the sum of the digits of given 'n digit integer number.