Home » SQL & PL/SQL » SQL & PL/SQL » online shopping catalogue system
online shopping catalogue system [message #575591] Thu, 24 January 2013 09:15 Go to next message
ade2013
Messages: 1
Registered: January 2013
Junior Member
pls forum help me or direct to write the pl sql for the online shoping

here is the detail

including order number, name and contact details (email, address, telephones) of customer and date the order was placed, order including product code, quantity ordered and cost charged; and Data on each product in the catalogue including product code, name, description, unit price and category.

user to input information
n number of order items (where 1 ≤ n ≤ 20) as parameters

a cursor to handle the multiple orders retrieved

your advise and input will be good
Re: online shopping catalogue system [message #575592 is a reply to message #575591] Thu, 24 January 2013 09:19 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: online shopping catalogue system [message #575599 is a reply to message #575591] Thu, 24 January 2013 10:55 Go to previous message
Michel Cadot
Messages: 59794
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Previous Topic: decode using multiple values
Next Topic: Multiple versions of PL/SQL management
Goto Forum:
  


Current Time: Wed Nov 26 18:43:10 CST 2014

Total time taken to generate the page: 0.09187 seconds