how can i do this i need help! can anybody help me to do this task?
Tiny Toys is a company that sells toys to schools and nurseries by mail order. Orders are taken over the phone by a number of sales consultants. The company already have a database with five tables set up. Table names and their columns are shown below:
TOYS (Toy_ID, Description, Rec_Retail_Price)
CUSTOMERS (Customer_ID, Name, Address, City, County, Post_Code, Account, Sales_Consultant_ID)
LINEITEMS (Order_ID, Toy_ID, Price, Quantity, Quantity_Sent)
ORDERS (ID, Customer_ID, Order_Date, Date_Sent, Sales_Consultant_ID, Total, Payment_With_Order, Order_Filled)
SALES_CONSULTANTS (ID, Last_name,First_name)
The above tables and the data can be found in k:\work\computing\Beryl Jones\plsqlcwk.sql. In order to do this assignment, you will need to create these tables in your own schema using the above script.
YOUR TASK
1. Write a procedure (not an anonymous block) to display details of all of the orders for a specific customer along with the customer
Tiny Toys is a company that sells toys to schools and nurseries by mail order. Orders are taken over the phone by a number of sales consultants. The company already have a database with five tables set up. Table names and their columns are shown below:
TOYS (Toy_ID, Description, Rec_Retail_Price)
CUSTOMERS (Customer_ID, Name, Address, City, County, Post_Code, Account, Sales_Consultant_ID)
LINEITEMS (Order_ID, Toy_ID, Price, Quantity, Quantity_Sent)
ORDERS (ID, Customer_ID, Order_Date, Date_Sent, Sales_Consultant_ID, Total, Payment_With_Order, Order_Filled)
SALES_CONSULTANTS (ID, Last_name,First_name)
The above tables and the data can be found in k:\work\computing\Beryl Jones\plsqlcwk.sql. In order to do this assignment, you will need to create these tables in your own schema using the above script.
YOUR TASK
1. Write a procedure (not an anonymous block) to display details of all of the orders for a specific customer along with the customer
.
