Escape character in sql queries
                                                 Last update (2008-10-14 14:40:59)
                                                                                                                   Date added (2008-02-17 16:38:49)

Summary
Like all scripting languages so and oracle sql has its escape character. If you execute in E-Business Suite
select * from all_tables where table_name like 'AP_%';
The results will not be all tables starting with AP_* as might be expected but all table starting with AP*

Now put the escape character at your statement to get exactly what you want.
select * from all_tables where table_name like 'AP<_%' ESCAPE '<';
Reviews
Filters
Search