| oracle form [message #389910] |
Wed, 04 March 2009 01:36  |
laith
Messages: 41
Registered: December 2008
Location: U.A.E
|
Member |
|
|
|
i have 2 fields (term_code ,log_number), i'm trying to write code for LOV in the log number feild that when term code is empty ...showing me all the term_code records.how can i do that !! thank you for your help.
|
|
|
|
| Re: oracle form [message #389919 is a reply to message #389910] |
Wed, 04 March 2009 02:26  |
 |
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
What do you want to display when TERM_CODE is not empty?
In the meantime, here's a lucky guess:
SELECT t.col_1, t.col_2, ...
FROM your_table t
WHERE t.term_code = NVL(:block.term_code, t.term_code) |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
