现在结果为:
field1 value1
field2 value2
field3 value3
field4 value4我想要的结果是
field1 field2 field3 field4
value1 value2 value3 value4也就是把filed作为字段名,value作为值,这样输出,有什么办法吗?
field1 value1
field2 value2
field3 value3
field4 value4我想要的结果是
field1 field2 field3 field4
value1 value2 value3 value4也就是把filed作为字段名,value作为值,这样输出,有什么办法吗?
解决方案 »
- 求一个时间比较语句
- ORACLE开发去日本的好机会!!!
- 急问!!!!!!!!!!!!!!!!!!!!!SQL语句
- 在安装oracle8i(linux8下)时,安装Oracle Database Configuration Assistant完后,安装starting web server in non_ssl mode on port77
- 中秋,送80,有需要QQ的也送!请再LINUX平台下搞ORACLE应用开发的留个QQ,并给些意见!
- 新手求助查询问题
- 此SQL语问怎样写?
- 创建存储过程,大侠助我!(在线等待)
- 把shp文件导入sde后,在oracle数据库内查看某字段长度与sde中不一致
- 请问能把RAC的机器时间往前调吗
- oracle left join查询问题,麻烦高手进来看看
- 如何让存储过程在没月的一号自动执行
看看下面这个例子也许对你有帮助:
“INSERT INTO t_col_row VALUES (6, NULL, NULL, 'v35');
INSERT INTO t_col_row VALUES (7, NULL, NULL, NULL);
COMMIT;SELECT * FROM t_col_row;1)UNION ALL
适用范围:8i,9i,10g及以后版本
SELECT id, 'c1' cn, c1 cv
FROM t_col_row
UNION ALL
SELECT id, 'c2' cn, c2 cv
FROM t_col_row
UNION ALL
SELECT id, 'c3' cn, c3 cv FROM t_col_row;若空行不需要转换,只需加一个where条件,
WHERE COLUMN IS NOT NULL 即可。”
最后我还是用游标做了处理
procedure sp_Check_Turn_Condition(
p_run_id in number,
p_condition in varchar2,
p_return OUT Cur_retrieve
)
as
m_sql varchar2(4000) := 'SELECT';
cursor cur
is
select itemTitle,
itemValue
from s_t_flow_run_item_value
where runid = p_run_id;
curType cur%rowtype;
begin
open cur;
loop
fetch cur into curType;
exit when cur%notfound;
m_sql := m_sql || ' ''' || curType.Itemvalue || ''' as ' || curType.Itemtitle || ',';
end loop;
m_sql := substr(m_sql, 0, length(m_sql) - 1);
m_sql := m_sql || ' FROM DUAL';m_sql := 'SELECT * FROM (' || m_sql || ') WHERE ' || p_condition;open p_return for m_sql;
end sp_Check_Turn_Condition;