摘要： There are two options when setting ResultSet to be scrollable:TYPE_SCROLL_INSENSITIVE - The result set is scrollable. Its cursor can move forward or b... 阅读全文

摘要： In this example we shall show you how to create and use a scrollable ResultSet. To use a scrollable ResultSet one should perform the following steps:L... 阅读全文

摘要： 1. with admin option是用在系统权限上的，with grant option是用在对象权限上的。SQL> grant create synonym to scott with grant option;grant create synonym to scott with grant option *第 1 行出现错误:ORA-01939: 只能指定 ADMIN OPTIONSQL> grant create synonym to scott with admin option;授权成功。SQL> grant update on scott.emp to hr 阅读全文

摘要： 转自 http://blog.chinaunix.net/uid-8504518-id-3325718.html今天开发人员问我如何快速并方便的查出一张表最近被更改的记录，这个需求很简单，由于是查最近被更改的数据，查回滚段就可以，下面是我做的小实验。SQL> create table test(id number,name varchar2(10),gender varchar2(5));表已创建。SQL> insert into test values(1,'宋春风','男'); 已创建 1 行。SQL> insert into test v 阅读全文