| Author |
Search Stored Procedure
|
mash john
Greenhorn
Joined: Sep 04, 2005
Posts: 15
|
|
Could anybody send me a sample stored procedure for querying data(Search).
Mash
|
 |
Dave Salter
Ranch Hand
Joined: Jul 20, 2005
Posts: 292
|
|
|
What database engine are you using. Can you be a bit more specific?
|
|
mash john
Greenhorn
Joined: Sep 04, 2005
Posts: 15
|
|
|
It's oracle .
|
|
Paul Sturrock
Bartender
Joined: Apr 14, 2004
Posts: 10336
|
|
|
In which case you already have example stored procedures in the documentation that came with Oracle. Read the "PL/SQL User's Guide and Reference".
|
JavaRanch FAQ HowToAskQuestionsOnJavaRanch
|
|
mash john
Greenhorn
Joined: Sep 04, 2005
Posts: 15
|
|
Just send me a sample stored procedure -dynamically passing the search criteria's and fetching the result.
Mash
|
|
Paul Sturrock
Bartender
Joined: Apr 14, 2004
Posts: 10336
|
|
|
Ok. Email (see my profile) me and we'll discuss my consultancy rates.
|
|
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26183
|
|
Mash,
You can google for a sample to base yours off.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: Search Stored Procedure
|
|
|
0
