Search a blob field in Oracle

SELECT * FROM my_schema.my_table t 
 WHERE dbms_lob.instr(t.my_blob,utl_raw.cast_to_raw(‘Searched string’))>0

Reference

[1] [http://blog.sbw.be/2006/09/13/oracle-search-inside-blob-content/](http://blog.sbw.be/2006/09/13/oracle-search-inside-blob-content/)

Installing Oracle instant client 11.2 on windows 7

Download the client [1] ,

extract to C:\oracle\instantclient_11_2

Add to system PATH

Computer > Properties > Advanced System settings > Advanced > Environment…

remove offending ssh key from ssh/known_hosts

sed -i 3d ./ssh/know_hosts

replace 3d with the number shown as the offending line.

Fixing ORA-02291: integrity constraint error when using Entity Framework with Oracle Database

This error is thrown because referential integrity is broken.

Normally EF is supposed to update the ID of the last inserted object, sometimes…

Display Raw HTML via ViewBag

Sometimes it may be necessary to pass in some arbitrary data to a view using the ViewBag say when the text you want to render is not directly associated with your model bound to the view.

Check if user is authenticated in MVC4

To see if the user has been authenticated so that you can enable/disable some links in your views. 
 below is the example that disables logout button when the user is not logged in.