|
Действия ...
Новые сообщения [новые:0]
Дайджест
Горячие темы
Избранное [новые:0]
Форумы
Пользователи
Статистика
Статистика нагрузки
Мод. лог
Поиск
|
|
21.01.2020, 08:18
|
|||
|---|---|---|---|
|
|||
Достать из 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:19
|
|||
|---|---|---|---|
Достать из Blob поля значение и из него нужные данные |
|||
|
#18+
Чудак, а при чём здесь blob? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
21.01.2020, 08:22
|
|||
|---|---|---|---|
|
|||
Достать из Blob поля значение и из него нужные данные |
|||
|
#18+
в таблице даты хранятся в таком виде: 2032322E30342E32303139000000000000000000000000 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
21.01.2020, 08:24
|
|||
|---|---|---|---|
|
|||
Достать из Blob поля значение и из него нужные данные |
|||
|
#18+
тип поля RAW ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
21.01.2020, 08:41
|
|||
|---|---|---|---|
|
|||
Достать из Blob поля значение и из него нужные данные |
|||
|
#18+
Вот запрос для примера with t (aa) as (select '30332E30322E323031352C2032312E30382E323031352C2031372E30382E323031362C2031372E30372E323031372C2032332E30352E323031382C2032392E30332E323031390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' from dual) select utl_raw.cast_to_varchar2(aa) from t ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
21.01.2020, 09:06
|
|||
|---|---|---|---|
|
|||
Достать из 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 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
start [/forum/topic.php?fid=52&mobile=1&tid=1881645]: |
0ms |
get settings: |
9ms |
get forum list: |
13ms |
check forum access: |
15ms |
check topic access: |
15ms |
track hit: |
52ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
40ms |
get tp. blocked users: |
1ms |
| others: | 257ms |
| total: | 414ms |
| 0 / 0 |
