Question: Part B: Answer the following using SQL developer. Use the schema of HR to answer this. Copy and paste your answer below each number. And

Part B: Answer the following using SQL developer.

Part B: Answer the following using SQL developer. Use the schema of HR to answer this. Copy and paste your answer below each number. And also paste the result of your answers. Save the sql script as TechSumm10_fullname 1. Create a sequence that starts with 1 , an interval of 2 and the biggest number is 999999 . Name the sequence as Sequence1. 2. Create a view that will show all the salaries and names of employees in the Administration department. 3. Create a synonym of the job_history table. Name the synonym as JHistory. 4. Create an anonymous block that would output your complete name of the screen. 5. Create an anonymous block to get the average of 5 numbers. Each number should come from the input of the user. 6. Create an anonymous block that will input the name of an employee, birthday, address and age. The name of the employee, birthday and address should come from the input of the user, while the age should be calculated based on his/her birthday

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!