Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL for WILDCARD searching

937334May 27 2012 — edited May 28 2012
Good Day,


Hi MASTER's got a little problem

got a table

DIESEL_DETAIL
___________

DATE_PO
PLATE_NO
DRIVER_NAME

I NEED TO SEARCH HERE'S MY QUERY

SELECT * FROM DIESEL_DETAIL
WHERE TO_CHAR(DATE_PO,'DD-MON-YYYY')
BETWEEN :P1_FROM
AND :P1_TO
AND PLATE_NO = :P1_PLATE_NO
OR DRIVER_NAME = :P1_DRIVER_NAME



ITS WORKING PERFECTLY BUT ITS MUST HAVE A VALUE
WHAT I WANT TO TO IS WHAT IF THE USER NOT INPUT THE VALUE
IT WILL AUTOMATICALLY EXECUTE THE WILDCARD SEARCH

IF THERE'S A POSSIBLE WAY?

THANKS MASTER'S GOOD DAY..
This post has been answered by ShankarViji on May 28 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2012
Added on May 27 2012
12 comments
1,002 views