select *
from TABLE_NAME
where dbms_lob.instr(COLUMNNAME,'searchtext') > 0;Thursday, October 4, 2018
Subscribe to:
Post Comments (Atom)
Popular Posts
-
So you are using Mercurial version control system and Tortoise Hg as its windows GUI tool. And after you made changes you accidentally click... -
To be able to use sys.dbms_lock a user should have been granted execution. begin DBMS_LOCK . Sleep ( 60 ); end ; PLS-00201 : identi...
-
Suppose we have column names We want to prepare them to use in a query and need to put double qutoes around them then put comma and comb... -
If you get this error for your user and want to get rid of it, first get the profile of user with this query: SELECT PROFILE FROM dba_us...
-
Problem: Data got committed in another/same session, cannot update row. Env: Oracle Sql Developer How to Solve: Uncheck below option -
select * from TABLE_NAME where dbms_lob . instr ( COLUMNNAME , 'searchtext' ) > 0 ;
-
declare @hexbin varbinary(max); declare @vbin varbinary(max); declare @hexstring1 varchar(8000) -- convert varbinary to hexstring sele...
-
Most of database jobs in the MSSQL2000 or MSSQL2005 world are done with Enterprise Manager or SQL Server Management Studio Express respectiv... -
sqlplus sys as sysdba alter user [username] identified by [password] account unlock;
-
Facts Float Type: 32 bit floating point number in the range from approximately 1.5 × 10 −45 to 3.4 × 10 38 with a precision of 7 d...
0 comments:
Post a Comment