模板如何将oracle的数据存储为json格式 redis键值的处理 ===================================================

￡神魔★判官ぃ 2022-12-11 09:12 105阅读 0赞

'"column_name":"' || column_name || '",' ||
    
    select '''"'||replace(lower(column_name),'_','') || '":"'' || ' || lower(column_name) ||    '||''",'' || ' from user_tab_columns where table_name='EMP';

json中的key带不带横杆不一定

1、将排序后的查询结果拼接起来  
select \* from(select  \*  from table order by a)

union

select \* from (select \* from table1 order by b)

union

select \* from (select \* from table2 order by c);

分页查询格式1  
在查询的最外层控制分页的最小值和最大值。查询语句如下：   
SELECT \* FROM  
(  
SELECT A.\*, ROWNUM RN  
FROM (SELECT \* FROM TABLE\_NAME) A  
)  
WHERE RN BETWEEN 21 AND 40

1.  select to\_char('aaa')from dual;--aaa
2.  select '' || to\_char('aaa') || ''from dual;--aaa
3.  select '''' || to\_char('aaa') || '''' from dual;--'aaa'
4.  select '''''' || to\_char('aaa') || '''''' from dual;--''aaa''
5.  select '''''''' || to\_char('aaa') || '''''''' from dual;--'''aaa'''
6.  select ' '' ' ||' ' || ' '' ' || to\_char('aaa') || ' '' '' ' from dual;-- '

下面是我的sql

![70][]

标题

实际结果

![70 1][]

转载地址：

[https://blog.csdn.net/qiuzhi\_\_ke/article/details/78892822][https_blog.csdn.net_qiuzhi_ke_article_details_78892822]

[https://blog.csdn.net/yin\_jia\_521/article/details/65990413][https_blog.csdn.net_yin_jia_521_article_details_65990413]

[https://blog.csdn.net/woshimyc/article/details/72519018][https_blog.csdn.net_woshimyc_article_details_72519018]

[https://blog.csdn.net/xzyxcy/article/details/82022126][https_blog.csdn.net_xzyxcy_article_details_82022126]

[https://blog.csdn.net/tanghuan0827/article/details/108409636][https_blog.csdn.net_tanghuan0827_article_details_108409636]

[70]: /images/20221123/5532aadcbebd4b048d1e679b90badb1c.png
[70 1]: /images/20221123/db2f442a1ee34d1c9e07d8fb2d390ae5.png
[https_blog.csdn.net_qiuzhi_ke_article_details_78892822]: https://blog.csdn.net/qiuzhi__ke/article/details/78892822
[https_blog.csdn.net_yin_jia_521_article_details_65990413]: https://blog.csdn.net/yin_jia_521/article/details/65990413
[https_blog.csdn.net_woshimyc_article_details_72519018]: https://blog.csdn.net/woshimyc/article/details/72519018
[https_blog.csdn.net_xzyxcy_article_details_82022126]: https://blog.csdn.net/xzyxcy/article/details/82022126
[https_blog.csdn.net_tanghuan0827_article_details_108409636]: https://blog.csdn.net/tanghuan0827/article/details/108409636