|
|
|
Достать из Blob поля значение и из него нужные данные
|
|||
|---|---|---|---|
|
#18+
Добрый день! Помогите советом пожалуйста. Вытащил данные из BLOB utl_raw.cast_to_varchar2(text) и получил список дат через запятую. Помогите выбрать последнюю дату из этого списка: 01.10.2017, 07.03.2018, 13.01.2019, 22.08.2019 Даты все время разные, могут быть и пустыми. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.01.2020, 08:18 |
|
||
|
Достать из Blob поля значение и из него нужные данные
|
|||
|---|---|---|---|
|
#18+
Чудак, а при чём здесь blob? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.01.2020, 08:19 |
|
||
|
Достать из Blob поля значение и из него нужные данные
|
|||
|---|---|---|---|
|
#18+
в таблице даты хранятся в таком виде: 2032322E30342E32303139000000000000000000000000 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.01.2020, 08:22 |
|
||
|
Достать из Blob поля значение и из него нужные данные
|
|||
|---|---|---|---|
|
#18+
тип поля RAW ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.01.2020, 08:24 |
|
||
|
Достать из Blob поля значение и из него нужные данные
|
|||
|---|---|---|---|
|
#18+
Вот запрос для примера with t (aa) as (select '30332E30322E323031352C2032312E30382E323031352C2031372E30382E323031362C2031372E30372E323031372C2032332E30352E323031382C2032392E30332E323031390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' from dual) select utl_raw.cast_to_varchar2(aa) from t ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.01.2020, 08:41 |
|
||
|
Достать из Blob поля значение и из него нужные данные
|
|||
|---|---|---|---|
|
#18+
Вроде получилось достать дату: with t (aa) as ( select '30332E30322E323031352C2032312E30382E323031352C2031372E30382E323031362C2031372E30372E323031372C2032332E30352E323031382C2032392E30332E323031390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' from dual) select substr(utl_raw.cast_to_varchar2(aa), LENGTH(substr(aa,1,instr(aa,'00000')-1))/2-9,10) as dat from t ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.01.2020, 09:06 |
|
||
|
|
start [/forum/topic.php?fid=52&msg=39916638&tid=1881645]: |
0ms |
get settings: |
8ms |
get forum list: |
15ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
45ms |
get topic data: |
9ms |
get forum data: |
2ms |
get page messages: |
44ms |
get tp. blocked users: |
2ms |
| others: | 15ms |
| total: | 148ms |
| 0 / 0 |
