oracle 笔记10 杂

--%rowtype的使用...
--不用使用于采用对象方式创建的表，如下，stu表是采用对象方式创建的，就不能执行
declare
stu_record1 stu%rowtype;
begin
    --stu_record1.id:=14;
    --stu_record1.name:='dklast';
    select id,name into stu_record1.id,stu_record1.name from stu where id = 1;
    insert into stu (id,name) values(stu_record1.id+2,stu_record1.name);
end;

 

net start OracleServiceORACLE9I
net start OracleOraHome92TNSListener 

--oracle下面比较重要的文件
.../oracle/ora92/network/admin/listener.ora   --保存监听器信息  
.../oracle/ora92/network/admin/tnsnames.ora   --保存数据库信息，如IP 

--查出记录数多于一条的记录
select * from  test where name in
(select name from
(select name, count(name) count from test group by name)
 where count>1);
another one
select distinct t1.rowid, t1.* from test t1, test t2 where t1.name=t2.name and t1.rowid<>t2.rowid;

--alter table person2  add (gender char(1));
--alter table person2  modify (gender char(2));
--alter table person2  drop (gender,position1);
--ALTER TABLE person2  RENAME COLUMN name1 TO name2;