| If else in Oracle SQL Query [message #545327] |
Tue, 28 February 2012 06:36  |
 |
m3nhaq
Messages: 20
Registered: September 2011
Location: Pakistan
|
Junior Member |
|
|
Hello Friends!
I need a solution of this query.
I want to write a single query in a procedure.
If procedure get rolNo = 'TR' , then it behave like this
Procedure Show_Records (rolNo = 'TR')
IS
Select c.date , c.rolNo
From my_table c
where c.date = system_date
AND c.rolNo = 'RT';
end;
else it behave like this
Procedure Show_Records (rolNo = 'TR')
IS
Select c.date , c.rolNo
From my_table c
where c.date = system_date
AND c.rolNo <> 'RT';
end;
Please, guide me . I am writing a complex query and cannot want to write 2 queries, just for <> and = operators.
Thanks.
|
|
|
|
| Re: If else in Oracle SQL Query [message #545330 is a reply to message #545327] |
Tue, 28 February 2012 07:37  |
flyboy
Messages: 1903
Registered: November 2006
|
Senior Member |
|
|
Hello,
firstly, you should rename the parameter differently than the column name (e.g. P_ROLNO), otherwise you will not be able to distinguish them in the query (Oracle will prefer column name).
Secondly, what about simply stating the conditions you wrote in SQL?
AND ( ( p_rolno = 'TR' and c.rolno = 'RT' )
OR ( p_rolno != 'TR' and c.rolno != 'RT' ) )
(you wanted to check the parameter for non-equality in the second snippet, did not you?)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
