sql - Sybase IQ 从用分隔符分隔的表中获取列列表的 sql 命令是什么。我们在 oracle 中使用以下命令
问题描述
下面是我使用的命令SQL developer
,结果是 Like Col1, Col2, Col3,..n
select listagg(COLUMN_NAME, ', ') within group (order by column_id asc)
from all_tab_columns
where table_name = 'NEIGHBORHOOD_ZIP_IQ';
解决方案
Sybase(现在是 SAP)IQ 构建在(或用作前端)Sybase(现在也是 SAP)SQLAnywhere 数据库引擎之上;最终结果是,根据您尝试执行的操作,您可以使用这两种产品的 SQL 构造(例如,函数)。
注意:我面前没有 IQ 数据库,因此您可能需要调整以下...
SQLAnywhere 有一个list()
功能类似于 Oracle 的listagg()
.
以下是显示 SYSTABLE 表中的列(以逗号分隔的列表)的几个示例:
# all of the following examples use the comma (',') as the delimiter
# output determined by order in which column names are pulled from table (probably column_id)
select list(c.column_name,',')
from SYSTABLE t
join SYSCOLUMN c
on t.table_id = c.table_id
where t.table_name = 'SYSTABLE'
go
table_id,file_id,count,first_page,last_page,primary_root,creator,first_ext_page,last_ext_page,table_page_count,ext_page_count,object_id,table_name,table_type,view_def,remarks,replicate,existing_obj,remote_location,remote_objtype,srvid,server_type,primary_hash_limit,page_map_start,source,encrypted,location_escape_char
# order the output by column_name
select list(c.column_name order by c.column_name,',')
from SYSTABLE t
join SYSCOLUMN c
on t.table_id = c.table_id
where t.table_name = 'SYSTABLE'
go
count,creator,encrypted,existing_obj,ext_page_count,file_id,first_ext_page,first_page,last_ext_page,last_page,location_escape_char,object_id,page_map_start,primary_hash_limit,primary_root,remarks,remote_location,remote_objtype,replicate,server_type,source,srvid,table_id,table_name,table_page_count,table_type,view_def
# order the output by column_id
select list(c.column_name order by c.column_id,',')
from SYSTABLE t
join SYSCOLUMN c
on t.table_id = c.table_id
where t.table_name = 'SYSTABLE'
go
table_id,file_id,count,first_page,last_page,primary_root,creator,first_ext_page,last_ext_page,table_page_count,ext_page_count,object_id,table_name,table_type,view_def,remarks,replicate,existing_obj,remote_location,remote_objtype,srvid,server_type,primary_hash_limit,page_map_start,source,encrypted,location_escape_char
推荐阅读
- javascript - HTML 单选按钮总是将最后一个选项提交给 PHP
- php - 使用代理的php套接字连接
- prolog - 如何摆脱序言中的重复项?
- java - 从大型未排序数组中删除重复项并保持顺序
- nginx-location - 为HTTP流量配置Nginx的反向代理出现403
- c# - 如何在新数据列中设置格式日期时间
- docker - Docker 容器失败,找不到文件
- javascript - 无法从 jquery 函数在 textarea 中添加###Name###
- python - pandas groupby 中未来行的条件搜索
- amazon-web-services - SES 模板/电子邮件无法呈现日文文本