SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-24-2008, 07:43 AM
| ||||
| ||||
 a need to store a few rows of data before final output I need to write a pl/sql block that will allow me to select a small quantity of rows from a table. These rows need to be manipulated with some further processing and finally all of the rows need to be returned from the procedure. I am using Delphi with Oracle 8I. If you cannot post a complete example please give me a book reference, link or somethink that I can follow without having to post back and forth 5 or 10 times. Thanks      |
|
02-24-2008, 07:43 AM
| |||
| |||
| Re: a need to store a few rows of data before final output UnixUser wrote: > I need to write a pl/sql block that will allow me to select a small > quantity of rows from a table. These rows need to be manipulated with > some further processing and finally all of the rows need to be > returned from the procedure. I am using Delphi with Oracle 8I. If > you cannot post a complete example please give me a book reference, > link or somethink that I can follow without having to post back and > forth 5 or 10 times. > > Thanks Excuse me but aren't you being paid to know how to do this? I am rarely this harsh but your posting seems to me outrageous. If you want someone to do your job for you shouldn't you be offering $ too? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond) |
|
02-24-2008, 07:44 AM
| |||
| |||
| Re: a need to store a few rows of data before final output Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1096089165.325897@yasure>... > UnixUser wrote: > > > I need to write a pl/sql block that will allow me to select a small > > quantity of rows from a table. These rows need to be manipulated with > > some further processing and finally all of the rows need to be > > returned from the procedure. I am using Delphi with Oracle 8I. If > > you cannot post a complete example please give me a book reference, > > link or somethink that I can follow without having to post back and > > forth 5 or 10 times. > > > > Thanks > > Excuse me but aren't you being paid to know how to do this? I am rarely > this harsh but your posting seems to me outrageous. If you want someone > to do your job for you shouldn't you be offering $ too? Actually, no. I am not getting paid for this I am learning. That is why I asked for a reference if someone knew where I could find one. I'll read. I'll study and I'll research, but the last thing I need is someone to reply like this to a post. You should have never responded to this if this is all you have to offer. |
|
02-24-2008, 07:44 AM
| |||
| |||
| Re: a need to store a few rows of data before final output UnixUser wrote: > I need to write a pl/sql block that will allow me to select a small > quantity of rows from a table. These rows need to be manipulated with > some further processing and finally all of the rows need to be > returned from the procedure. I am using Delphi with Oracle 8I. If > you cannot post a complete example please give me a book reference, > link or somethink that I can follow without having to post back and > forth 5 or 10 times. > > Thanks Not quite sure what you are trying to accomplish. Even less sure of the purpose of Delphi, as compared to any other language or environment such as SQL*Plus. All I can therefore suggest is some resources: 0) Book: Effective Oracle by Design 1) http://otn.oracle.com >> PL/SQL (Select Sample Code) 2) http://otn.oracle.com >> Oracle By Example (Select Training) 3) http://www.oraclepress.com >> Search for PL/SQL 4) http://oracle.oreilly.com & look through the list 5) http://www.google.com >> Search fr PLSQL Examples 6) http://docs.oracle.com & browse for Application Developer's Guide HTH /Hans |
|
02-24-2008, 07:44 AM
| |||
| |||
| Re: a need to store a few rows of data before final output On 24 Sep 2004 20:53:18 -0700, rafel.coyle@pfshouston.com (UnixUser) wrote: >I need to write a pl/sql block that will allow me to select a small >quantity of rows from a table. These rows need to be manipulated with >some further processing and finally all of the rows need to be >returned from the procedure. I am using Delphi with Oracle 8I. If >you cannot post a complete example please give me a book reference, >link or somethink that I can follow without having to post back and >forth 5 or 10 times. The feature that sounds like it matches most closely is Pipelined Table Functions, but they're only available from 9i. What's the nature of the manipulation and processing; can it not be done in an SQL statement? Other things to look up could perhaps be Global Temporary Tables and Ref Cursors (do your data munging in a global temporary table, and then return a ref cursor selecting that data). Or return a PL/SQL table type - if your Delphi interface supports this type. -- Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk> <http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool |
|
02-24-2008, 07:44 AM
| ||||
| ||||
| Re: a need to store a few rows of data before final output UnixUser wrote: > Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1096089165.325897@yasure>... > >>UnixUser wrote: >> >> >>>I need to write a pl/sql block that will allow me to select a small >>>quantity of rows from a table. These rows need to be manipulated with >>>some further processing and finally all of the rows need to be >>>returned from the procedure. I am using Delphi with Oracle 8I. If >>>you cannot post a complete example please give me a book reference, >>>link or somethink that I can follow without having to post back and >>>forth 5 or 10 times. >>> >>>Thanks >> >>Excuse me but aren't you being paid to know how to do this? I am rarely >>this harsh but your posting seems to me outrageous. If you want someone >>to do your job for you shouldn't you be offering $ too? > > > Actually, no. I am not getting paid for this I am learning. That is > why I asked for a reference if someone knew where I could find one. > I'll read. I'll study and I'll research, but the last thing I need is > someone to reply like this to a post. You should have never responded > to this if this is all you have to offer. http://www.psoug.org Click on Morgan's Library Click on Bulk Binding / Bulk Collection -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond) |
Linear Mode
