#1 03 Mar 2010 02:44

Soo Thoe See Mun
Registered: 03 Mar 2010
Posts: 1

Need Assistance On PL/SQL Coding


I'm doing the procurement system and I need to generate a report base on the <request_no> to locate each <order_item> record which had ordered for last two years.

For example:

request_no: REQ10010001
Order Item:

ITEM                                                         Output
=====                                                     =======
1. LAMP PILOT TUBULAR CLEAR E-1          SEP'09 (75 pcs), NOV'09 (50 pcs)
2. LAMP PILOT TUBULAR CLEAR E-2          DEC'08 (16pcs), AUG'09 (12 pcs), OCT'09 (80 pcs)
3. LAMP PILOT TUBULAR CLEAR E-3          SEP'09 (4 pcs)

Note: Generate the output as of today's query date, to locate back the past two years record and count the no. of pieces ordered /per item /per month.

Please advice should I use function or store procedure to return the record?
Please assist to provide the code sample on this for easy reference.

Best regards,


#2 04 Mar 2010 21:01

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 939

Re: Need Assistance On PL/SQL Coding

You haven't provided enough information for anyone to be able to help you with this

Operating system?

Version of Oracle?

Language/tools you are using to write reports?

Structure of the tables/columns ?



#3 08 Feb 2011 15:06

Registered: 08 Feb 2011
Posts: 1

Re: Need Assistance On PL/SQL Coding

Am very new to Oracle. I really need help on the best way to get proficient in the Oracle 10g and 11g,

on both the linux and Windows platform. Do i start from the PL/SQL and to where, am looking for

consistency while learning oracle on both the platforms.

Thank you


#4 16 Dec 2011 03:36

Registered: 15 Dec 2011
Posts: 17

Re: Need Assistance On PL/SQL Coding

What do you mean by "learning Oracle"?  Programming?  Architecting?  Administration?  You need to be more specific.

As for "getting proficient", maybe you could try some hands on with actual Oracle software running on your own equipment along with books and Oracle's excellent documentation.



Board footer

Powered by FluxBB