8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Dynamic Binds Using Contexts


kervoaz said...

excellent
thank you

Charlie 木匠 said...

A better solution:

http://www.oracle.com/technology/oramag/oracle/09-jul/o49asktom.html

here is the new approach:

14 if ( p_ename is NOT NULL )
15 then
16 l_query := l_query ||
17 ' where ename like
18 ''%''||:p_ename||''%'' ';
19 else
20 l_query := l_query ||
21 ' where (1=1 or
22 :p_ename is null) ';
23 end if;

Tim... said...

Hi.

That approach has been around for a while now. I would describe it as a "different" approach, rather than a "better" one. Each have their positive and negative points.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.