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

'"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

标题

     实际结果

     

转载地址：

https://blog.csdn.net/qiuzhi__ke/article/details/78892822

https://blog.csdn.net/yin_jia_521/article/details/65990413

https://blog.csdn.net/woshimyc/article/details/72519018

https://blog.csdn.net/xzyxcy/article/details/82022126

https://blog.csdn.net/tanghuan0827/article/details/108409636