I am using SUBSTR method in SQL query but due to long string it is giving below error: ERROR: ORA-01704: string literal too long. Examples. Re: How to extract the substring from LONG datatype column 121256 Jan 17, 2007 8:31 AM ( in response to 528801 ) I have problem with extracting some substring from LONG datatype … Praveen I get an err Oracle 11G. Answer: First, the LONG and LONG RAW datatypes are superseded by the new LOB datatypes (CLOB, BLOB and BFILE), and I would consider re-defining the table to have a LOB column instead of raw. In SQL Server, you can use SUBSTRING function, but it does not allow you to specify a negative start position, and the substring length must be specified . 以上、oracleで文字列で切り取るsubstr・substrbでした。 ... バイナリデータ型 blob・bfile・raw・long raw oracleのバイナリデータ型は blob・bfile・raw・long rawがあります。それぞれどのような違いがあるのか解説します。 Thanks. The Oracle/PLSQL REGEXP_SUBSTR function is an extension of the SUBSTR function. working with long columns. In case the substring_length is less than 1, the SUBSTR() function returns null. SQL: select * from table where tn=SUBSTR('....LONG STRING....',1,12) please suggest any alternate solution to allow substring on long string in oracle SQL query. Question: I need to select a LONG RAW column from a table.How do you select a LONG or LONG RAW table column in SQL? The LONG and LONG RAW datatypes have been deprecated in favour of LOBs for many Oracle versions, yet they still exist in the data dictionary and legacy systems. Return value. For this reason, it is still quite common to see questions in Oracle … Let’s see the following example: SELECT SUBSTR ( 'Oracle Substring', 1, 6) SUBSTRING … In Oracle, SUBSTR function returns the substring from a string starting from the specified position and having the specified length (or until the end of the string, by default). Examples in Oracle/PLSQL of using the substr() function to extract a substring from a string: The general syntax for the SUBSTR() function is: SUBSTR( source_string, start_position, [ length ] ) "source_string" is the original source_string that the substring will be taken from. I am trying to run this query against the dictionary which has a column of long data type. Also see Insert into long raw column Tips. 一直以来都是用substr()来截取字符串的一部分，虽然知道有substrb()，也知道substrb()是以byte(字节)来计算长度，可没用过，也不太明白什么地方需要用到它们，今天刚好测试了一下这两个函数，就做点总结：首先来介绍下这两个函数函数名 说明SUBSTR(c1_oracle substr The SUBSTR() function returns a substring from the str starting at start_position with the substring_length length. Re: Convert Long to Char or Varchar issue. This function, introduced in Oracle 10g, will allow you to extract a substring from a string using regular expression pattern matching. Content tagged with oracle to oracle, obiee* Content tagged with obiee* 1. TRIM: TRIM(‘ ABC ‘) ‘ABC’ Remove the space character or … TRANSLATE: TRANSLATE(‘12345’, ‘143’, ‘bx’) ‘b2x5’ Replace all occurrences of characters by other characters in a string.