#1 03 Mar 2010 02:44

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

Need Assistance On PL/SQL Coding

Hi,

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,
sm

Offline

#2 04 Mar 2010 21:01

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 902
Website

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 ?

http://ss64.org/viewtopic.php?id=878

Offline

#3 08 Feb 2011 15:06

mkarichu
Member
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

Offline

#4 16 Dec 2011 03:36

Opus
Member
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.

Cheers,
Opus

Offline

Board footer

Powered by FluxBB