有这样一个表;
create table student(
ID integer not null generated by default as identity,
S_NAME varchar(8) not null,
S_NO varchar(8) not null,
S_SEX varchar(4) not null,
S_AGE integer not null,
primary key (ID))insert into student values(1,'Jack','0101','男',19);
insert into student values(2,'Mike','0104','女',26);
insert into student values(3,'Isabel','0102','女',24);
insert into student values(4,'Coral','0106','男',22);我要查询得到的结果是:
name1 name2 name3 name4
Jack Mike Isabel Coral怎么写sql语句呢??
create table student(
ID integer not null generated by default as identity,
S_NAME varchar(8) not null,
S_NO varchar(8) not null,
S_SEX varchar(4) not null,
S_AGE integer not null,
primary key (ID))insert into student values(1,'Jack','0101','男',19);
insert into student values(2,'Mike','0104','女',26);
insert into student values(3,'Isabel','0102','女',24);
insert into student values(4,'Coral','0106','男',22);我要查询得到的结果是:
name1 name2 name3 name4
Jack Mike Isabel Coral怎么写sql语句呢??
解决方案 »
- 如何查看日志
- 用sql语句插入clob字段
- toad 9.7 菜单里没有DBA...
- 各位有经验的DBA麻烦帮我诊断一下我的oracle
- 采用full outer join后SQL语句执行太慢,结果出不来了
- JDBC连ORACLE的驱动问题。。。。。。。
- 用pl/sql查看ORACLE数据时乱码的问题
- 日期问题
- oracle 数据迁移的 sqlServer的问题
- 8i 在 P4上如何装?在线等待,急,急,急,急,急,急,急,急,急,急!!!!
- 那位师兄给详细说下oracle的客户端和服务端有什么区别?
- 查询带"6666"的手机号.排除带66666,666666,666,6666666等手机号的查询语句.
可参考:
http://topic.csdn.net/u/20120229/23/3a35d700-d90d-462a-99bc-d27ca0fab845.html?79780