Question
Change the structure of Employee table by adding a new column called Address of type varchar2 (50). [1.5 mark] Write a SQL statement to create
Change the structure of Employee table by adding a new column called Address of type varchar2(50). [1.5 mark]
Write a SQL statement to create a view named 'Employees_Purchase which will contain First Name, Last name and Salary of employees who are working in Purchasing department.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Systems For Advanced Applications 18th International Conference Dasfaa 2013 Wuhan China April 22 25 2013 Proceedings Part 2 Lncs 7826
Authors: Weiyi Meng ,Ling Feng ,Stephane Bressan ,Werner Winiwarter ,Wei Song
2013th Edition
3642374492, 978-3642374494
