12.28.05
ASK TOM之中英文对照20051228——–关于DUAL表
ASK TOM之中英文对照20051228————关于DUAL表
本人文档,如需转载,请注明出处.
Tom 您好
在沉默一段时间后提问感觉非常好
看下面的例子
12.23.05
ASKTOM之中英文对照20051223-本地管理表空间
ASKTOM之中英文对照20051223-本地管理表空间
本人文档,如需转载,请注明出处.
译文:
本地管理表空间
晚上好 tom
12.22.05
AskTom翻译一篇–package privilige
Hi Tom,
I wrapped several stored procedures in a package and grant execute privilege on
this package to a role, then everybody having this role would be able to run ANY
PROCEDURES IN THIS PACKAGE. This is not exactly what I want. Is there any
CLEAN way to do the following:
create or replace package pkg_my
as
procedure a;
procedure b;
procedure c;
end;
grant execute on pkg_my.A to USER1;—illegal
grant execute on pkg_my.B to USER2;—illegal
....
I want to be able to assign different execute privilege against different
procedures IN A PACKAGE to different users.
Thanks,
译文：
你好，TOM
我加密了包里面的几个存储过程并且把这个包的执行权限授予一个角色，然后具有这个角色的所有人都能够执行包中的任何存储过程。
这个不是我真正想要的结果，有没有简洁的方法能像下面一样：
12.13.05
一致性获取―――非常迷惑
翻译自asktom
原文地址
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:880343948514#53164728392094
本人文档 如需转载 请注明出处
问
create table test( a int);
begin
for i in 1..10000 loop
insert into test values (i);
end loop;
end;
set autotrace on
select count(0) from test;
Execution Plan————————————————————————————— 0 SELECT STATEMENT Optimizer=CHOOSE
1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF ‘TEST’Statistics————————————————————————————— 0 recursive calls
4 db block gets 20 consistent gets 0 physical reads 0 redo size 369 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed Read the rest of this entry »