摘要: 主机字符串:as sysdbaalter user scott account unlock;//解锁scott,不会就谷歌检索DML语句,增、删、查、改 select语句:熟悉表结构 desc emp;number(4) 4位数字类型number(7,2) 7位数字,2位小数varchar2(10) 10位可变长度字符串date 日期类型select * from salgrade s;select s.* from salgrade s;select ename, sal * 12 as "Annual Salary" from emp;//有空格时使用双引号;双引号内 阅读全文
posted @ 2014-03-13 15:56 jht_newbie 阅读(282) 评论(0) 推荐(0) 编辑