I've been staring at this forever and I can't even find a starting point. I don't know if anyone on here could help with this, but I would greatly appreciate it...
I guess I don't know SQL as well as I thought I did. Everything I've tried has failed. I typed in some of my code already but I left it empty because what I'm doing isn't working. If you could help me or offer me a section of code I would appreciate it. I think I'm over thinking the project... I heard it's not too hard but I'm struggling a lot.
This project will involve the use of “cust” table. You are to create a package that has a procedure to add a new customer, a procedure to update the customer information (city, state), a procedure to remove a customer and a procedure to report customer information by state.
http://i57.tinypic.com/3304upt.jpg
----------
I'm not asking for solutions, although if you do want to do them I will not defer you from that. I need help, suggestions, a starting point. Please and thank you !!!!!!
I guess I don't know SQL as well as I thought I did. Everything I've tried has failed. I typed in some of my code already but I left it empty because what I'm doing isn't working. If you could help me or offer me a section of code I would appreciate it. I think I'm over thinking the project... I heard it's not too hard but I'm struggling a lot.
This project will involve the use of “cust” table. You are to create a package that has a procedure to add a new customer, a procedure to update the customer information (city, state), a procedure to remove a customer and a procedure to report customer information by state.
http://i57.tinypic.com/3304upt.jpg
----------
I'm not asking for solutions, although if you do want to do them I will not defer you from that. I need help, suggestions, a starting point. Please and thank you !!!!!!