'"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
-
select to_char('aaa')from dual;--aaa
-
select '' || to_char('aaa') || ''from dual;--aaa
-
select '''' || to_char('aaa') || '''' from dual;--'aaa'
-
select '''''' || to_char('aaa') || '''''' from dual;--''aaa''
-
select '''''''' || to_char('aaa') || '''''''' from dual;--'''aaa'''
-
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