Monday, February 22, 2010

Get rid of quotes signs ' with Oracle 10g and 11g

Hi,

Recently i have posted this topic on my blog with Oracle 10 and 11g you can avoid the use of additional quotes signs when creating any Literal string ...

Like in reports it is common for us to write something similar to this

e.g  ' where hiredate between '||''''||p_from_date||''''||' and '||''''||p_to_date||''''

Click here for more info 

Now u can follow me on Twitter as well 

Have a nice day,
Baig
http://baigsorcl.blogspot.com/

No comments:

Post a Comment