what are wild cards incase of sql

hello everybody ..can anyone explain me what are wildcards and how they are used with stored procedures and why

re: what are wild cards incase of sql

Wild cards are used for pattern matching.
In oracle 2 wild cards are used .
%-----for zero or more characters
_------for 1 character only.

re: what are wild cards incase of sql

Hi avimel,

Welcome to TDSN!!

Please make sure you follow POSTING GUIDELINES every time you post in this forum.

Thanks
MODERATOR

re: what are wild cards incase of sql

The LIKE condition allows you to use wildcards in the where clause of an SQL statement. This allows you to perform pattern matching. The LIKE condition can be used in any valid SQL statement - select, insert, update, or delete.

The patterns that you can choose from are:

% allows you to match any string of any length (including zero length)

_ allows you to match on a single character

re: what are wild cards incase of sql

For More on Pattern Matching and Regular Expressions 10g, you can refer our forum articles:

REGEXP_LIKE
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR