Toggle navigation
Toggle navigation
Home
Products
About us
Support
Contact
Try it free
order
Register
Log In
Forums
Products
Direct Oracle Access
TOracleQuery with NULL variables
Search
Advanced Forum Search
Forums
Active Threads
Print Thread
TOracleQuery with NULL variables
#48607
02/16/14
02:15 PM
Joined:
Mar 2013
Posts: 8
N
nrsgzz
OP
Member
OP
nrsgzz
Member
N
Joined:
Mar 2013
Posts: 8
Hi all.
I have a query that uses variables, something like this
SQL Query
SELECT
*
FROM
MYTAB A
WHERE
A.COL1 = :COL1
AND
A.COL2 = :COL2
However the variables could be null and in that case the query will never return any results.
How can I make it work?
Copy Link to Clipboard
Entire Thread
Subject
Posted By
Posted
TOracleQuery with NULL variables
nrsgzz
02/16/14
02:15 PM
Re: TOracleQuery with NULL variables
Marco Kalter
02/17/14
11:33 AM
Moderated by
support
Hop To
Products ------
Plyxon
PL/SQL Developer
Direct Oracle Access
Query Reporter
Alpha / Beta releases ------
Plyxon Alpha / Beta
PL/SQL Developer 15.0 Beta
Print Thread
Switch to Flat Mode
Show Likes
Link Copied to Clipboard
View Profile
Private Message
Follow User
Forum Posts
Privacy Policy
·
Forum Rules
·
Mark All Read
Contact Us
·
Forum Help
·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:
PHP:
7.1.33
Page Time:
0.103s
Queries:
15 (0.084s)
Memory:
2.5233 MB (Peak: 3.0398 MB)
Data Comp:
Off
Server Time:
2024-05-07 00:34:24 UTC
Valid HTML 5
and
Valid CSS