摘要: 阅读全文
posted @ 2017-09-16 19:53 待你君临天下 阅读(67) 评论(0) 推荐(0)
摘要: 使用列的别名(as)select ename as "姓名", (sal+nvl(comm,0))*12 as "年薪" from emp;--as "别名"select ename as 姓名, (sal+nvl(comm,0))*12 as 年薪 from emp;--as 别名select e 阅读全文
posted @ 2017-09-12 17:23 待你君临天下 阅读(106) 评论(0) 推荐(0)
摘要: 系统中基金公司表(FundCompany)create table fc(companyid varchar2(20) primary key,name varchar2(30) not null,content clob not null,money number(10,2),state numb 阅读全文
posted @ 2017-09-09 15:58 待你君临天下 阅读(96) 评论(0) 推荐(0)