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
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
Messages: 25581
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

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: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Previous Topic: Multiple versions of PL/SQL management
Next Topic: Goto option not working in EXCEPTION
Goto Forum:

Current Time: Thu Aug 24 01:58:45 CDT 2017

Total time taken to generate the page: 0.01746 seconds