摘要：
--创建表 create table worth( evday varchar2(52), weather varchar2(10), temperature number(10)) select * from worth; --插入行内容 insert into worth (ev... 阅读全文
摘要：
declare V_name emp.ename%TYPE :='SMITH';--定义成emp.ename类型,其初始化值必须在ename中存在 V_job varchar (20) :='salesman'; V_sal number ; rec emp%rowtype; begin select * into rec from emp where ename = V_na... 阅读全文
摘要：
select * from scott.emp; select ename "name"from scott.emp; --lower转化小写的用法 select lower(ename) ename ,sal from scott.emp; select * from scott.emp where lower(ename)='allen'; --upper 转化大写 select uppe... 阅读全文