Oracle Database Discussion Forum
Powered by
Build-Reciprocal-Links.com
Register
Members List
Search
FAQ
Invite Your Friends
BRL $ Store
Please Login
Members Login.
User Name:
Password:
Remember Me?
Please register
HERE
to be part of our Community
Contest of the Day.
Participate and Earn $$$.
Contest # 5 - 1st July to 14th July (Top Referrers For
JobsIn Forum
)
Contest # 4 (Free/ Paid Domain Registrar Listing)
Top Referrer Contest (22nd May - 5th June)
Contest for 20th May & 21st May, 2008
Current Promotions.
Post a
New Thread
anywhere on
Search Engine Optimization Board
and earn BRL$ 5 for every thread.
Earn By Posting
Participate in forum and Earn $$$.
Referrer Credit - BRL$ 100
Positive Rep Cr. - BRL$ 3
New Thread Cr.- BRL$ 3
Posting Cr. - BRL$ 2
Post size Credit
Full List of BRL$ Earnings
Sponsors.
Webmaster Forum - Search Engine, Web Design, Web Development, Link Exchange Forum
»
Programming & Web Development
»
Database
»
Oracle Database
» Search on a table with optional parameters
Oracle Database
Discussion related to Oracle database issues, queries, questions
Thread Tools
#
1
(
permalink
)
09-20-2007
Rss_Feeds
Administrator
Join Date: Jun 2007
Posts: 3,729
BRL$:
25,979.15
Rep Power:
399
Search on a table with optional parameters
Hi, We have search procedures with parameters that are optional. In our select statements, we ignore all the parameters that are nulls. Here is an example of a table and a procedure to achieve this: create table TEMP_TEMPLATE ( OBJECT_I...
More...
__________________
█
High Quality
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
█
Powerful
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
█
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Current Promotions...
Post a
New Thread
anywhere on
Search Engine Optimization Board
and earn BRL$ 5 for every thread.
Important - Read before posting
Please carefully read the
Global Rules
and Posting Rules for
GPT / Buy - Sell Offers / Link Exchange
sections before posting.
«
recovery after losing UNDO tablespace
|
Data Archival and Retrieval
»
Currently Active Users Viewing This Thread: 1
(0 members and 1 guests)
Thread Tools
Show Printable Version
Email this Page
Posting Rules
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Trackbacks
are
On
Pingbacks
are
On
Refbacks
are
On
Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
List of Top Search Engines
DESIGAC
Search Engine Optimization
4
03-24-2008
05:47 AM
Affiliate Marketers Guide To Search Engine Optimization
Jason
Search Engine Optimization
0
09-04-2007
09:50 AM
I want to search for a single word in a field on a SQL table...
Rss_Feeds
PHP
0
07-19-2007
08:36 PM
Creating Table Partitions in SQL Server 2005
mr_atom
Microsoft SQL Server
0
07-16-2007
08:01 PM
load a pl/sql table with lookup table and use it in my program for look up values
Rss_Feeds
Oracle Database
0
07-09-2007
05:41 AM
-- Default Style
-- ftheme red
-- fluid theme
LinkBack
LinkBack URL
About LinkBacks
Bookmark & Share
Digg this Thread!
Add Thread to del.icio.us
Bookmark in Technorati
Furl this Thread!
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
Search on a table with optional parameters 
