Zourab's questions

有什么方法可以让用户知道并非所有内容都适合弹性容器？

任何图标、符号、文字等，text-overflow: ellipsis;都可以设置为纯文本。

.list-panel {
  display: flex;
  overflow-x: clip;
  width: 300px; /* <<----- */
  gap: 8px;
  padding: 10px;
  background: skyblue;
}

.item {
  background: lightcyan;
}

<div class="list-panel">
  <span class="item">111111111111</span>
  <span class="item">222222222222</span>
  <span class="item">333333333333</span>
  <span class="item">444444444444</span>
  <span class="item">555555555555</span>
  <span class="item">666666666666</span>
</div>

我编写了一个 ORACLE PL-SQL 函数，使用 REGEXP_REPLACE 将字符串从 camelCase 转换为 snake_case。下面是函数本身：

create function camel_to_snake(str varchar2) return varchar2 as
begin
    return
        lower(
            regexp_replace(
                regexp_replace (
                    str,
                    '([A-Z])([A-Z][a-z])',
                    '\1_\2',
                    1, 0, 'c'
                ),
                '([a-z])([A-Z])',
                '\1_\2',
                1, 0, 'c'
            )
        );
end;

一段时间后发现，该函数的结果取决于客户端参数 NLS_LANG。

为了使该功能正常工作，必须指定语言和地区 - AMERICAN_AMERICA

select
    column_value as camel_case,
    camel_to_snake(column_value) as snake_case
from
    table(t_varchar_table(
        'Foo',
        'FooBar',
        'foobar'
    ));


CAMEL_CASE                               SNAKE_CASE
---------------------------------------- ----------------------------------------
Foo                                      foo
FooBar                                   foo_bar
foobar                                   foobar

否则它将返回无意义的内容（西里尔语言）：

select
    column_value as camel_case,
    camel_to_snake(column_value) as snake_case
from
    table(t_varchar_table(
        'Foo',
        'FooBar',
        'foobar'
    ));


CAMEL_CASE                               SNAKE_CASE
---------------------------------------- ----------------------------------------
Foo                                      f_o_o
FooBar                                   f_o_ob_a_r
foobar                                   f_o_ob_a_r

如何修复它，以便函数的结果不依赖于客户端参数？

我需要将 ORACLE 表中的分组数据以树结构的形式放入 JSON 对象中

Oracle 版本 19c（如果重要）

该表将如下所示：

create table a_table (
    store    varchar2(100),
    brand    varchar2(100),
    product  varchar2(100),
    quantity number,
    amount   number
);

insert into a_table t (store, brand, product, quantity, amount) values ('All Motors Store', 'BWM', 'Car', 22, 57000);
insert into a_table t (store, brand, product, quantity, amount) values ('All Motors Store', 'BWM', 'Motorbike', 66, 37000);
insert into a_table t (store, brand, product, quantity, amount) values ('All Motors Store', 'CGM', 'Car', 88, 61000);
insert into a_table t (store, brand, product, quantity, amount) values ('All Motors Store', 'CGM', 'Motorbike', 77, 25000);
insert into a_table t (store, brand, product, quantity, amount) values ('All Motors Store', 'CGM', 'Bicycle', 14, 2000);
insert into a_table t (store, brand, product, quantity, amount) values ('Vehicle Store', 'BWM', 'Car', 2, 40000);
insert into a_table t (store, brand, product, quantity, amount) values ('Vehicle Store', 'BWM', 'Motorbike', 6, 22000);
insert into a_table t (store, brand, product, quantity, amount) values ('Vehicle Store', 'BWM', 'Bicycle', 6, 2300);
insert into a_table t (store, brand, product, quantity, amount) values ('Vehicle Store', 'CGM', 'Car', 8, 50000);
insert into a_table t (store, brand, product, quantity, amount) values ('Vehicle Store', 'CGM', 'Motorbike', 7, 21000);
commit;

结果结构必须是这样的：

{
    "items": [
        {
            "key": "All Motors Store",
            "summary": [267, 182000],
            "items": [
                {
                    "key": "BWM",
                    "summary": [88, 94000],
                    "items": [
                        {
                            "key": "Car",
                            "summary": [22, 57000]
                        },
                        {
                            "key": "Motorbike",
                            "summary": [66, 37000]
                        }
                    ]
                },
                {
                    "key": "CGM",
                    "summary": [179, 88000],
                    "items": [
                        {
                            "key": "Bicycle",
                            "summary": [14, 2000]
                        },
                        {
                            "key": "Car",
                            "summary": [88, 61000]
                        },
                        {
                            "key": "Motorbike",
                            "summary": [77, 25000]
                        }
                    ]
                }
            ]
        },
        {
            "key": "Vehicle Store",
            "summary": [29, 135300],
            "items": [
                {
                    "key": "BWM",
                    "summary": [14, 64300],
                    "items": [
                        {
                            "key": "Bicycle",
                            "summary": [6, 2300]
                        },
                        {
                            "key": "Car",
                            "summary": [2, 40000]
                        },
                        {
                            "key": "Motorbike",
                            "summary": [6, 22000]
                        }
                    ]
                },
                {
                    "key": "CGM",
                    "summary": [15, 71000],
                    "items": [
                        {
                            "key": "Car",
                            "summary": [8, 50000]
                        },
                        {
                            "key": "Motorbike",
                            "summary": [7, 21000]
                        }
                    ]
                }
            ]
        }
    ],
    "summary": [296, 317300]
}

实现这一目标的最佳方法是什么？