: GETTING FIRST 250
CHARACTERS FROM A LONG DATATYPE
Stephane,
You could write a plsql by defiining a variable with 32K (like
fetch_log_valuevarchar2(32760))
You could fetch the long data type column value into fetch_long_value
variable after opening the cursor. After that you can use substr on this
variable.
Baskar
-Original
Mark,
You could write a plsql by defiining a variable with 32K (like
fetch_log_valuevarchar2(32760))
You could fetch the long data type column value into fetch_long_value
variable after opening the cursor. After that you can use substr on this
variable.
Baskar
-Original Message-
HI GURUS,
If I have a table that has a field with long data type and I want to get the
first 250 characters out of it how can I do it. I tried using SUBSTR(long
data type field, 1, 250) but it complained about ORA-00932: inconsistent
datatypes. I then tried TO_CHAR(SUBSTR(long data type field,
Mark Liggayu wrote:
HI GURUS,
If I have a table that has a field with long data type and I want to get the
first 250 characters out of it how can I do it. I tried using SUBSTR(long
data type field, 1, 250) but it complained about ORA-00932: inconsistent
datatypes. I then tried