10g ?????????
{???????????}
SELECT * FROM RECYCLEBIN
{???????????}
PURGE RECYCLEBIN
{?????????????}
PURGE TABLE ?????
{???????????????}
PURGE INDEX ???????
{?????????????????}
PURGE TABLESPACE ?????????
« 2007年06月 | ??? | 2007年08月 »
{???????????}
SELECT * FROM RECYCLEBIN
{???????????}
PURGE RECYCLEBIN
{?????????????}
PURGE TABLE ?????
{???????????????}
PURGE INDEX ???????
{?????????????????}
PURGE TABLESPACE ?????????
?DBA_SYS_PRIVS??????????????????????
SELECT * FROM DBA_SYS_PRIVS
??CONNECT??????????????????
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = 'CONNECT'
????Oracle????????CONNECT,DBA,RESOURCE ????????????????
??????
??????????
SELECT * FROM DBA_ROLES
??????????????????????????
SELECT * FROM DBA_ROLE_PRIVS
?????????????????????
2??????6?????????????
????????????????????
??????????????????????????
?????????????????????
?????????????????????????????????????
??????????Free------dom???????????????
select * from v$version
prototype??JavaScript???????????
?????!!
????????JavaScript???????
??????JavaScript??????
???????-30??????
?VrSetForm?????????????????????????
??????????????????????????????????
???????????????????????????
???????????????????????????????????????
DBMS_OUTPUT????????????????????????????
ORACLE 10G R1?????????????2K????1M????????255????
?????????????????
DBMS_OUTPUT.ENABLE(1000000);
ORACLE 10G R2??????????2K????????????32K???
DBMS_OUTPUT.ENABLE(NULL);
+-----------------+----------------------------------+
| ORU-10027 | ??????????? |
+-----------------+----------------------------------+
| ORU-10028 | ??????????? |
+-----------------+----------------------------------+
??????????
?PROCEDURE?FUNCTION?PACKAGE?PACKAGE BODY?TRIGGER?TYPE?TYPE BODY?
????????????????USER_PLSQL_OBJECT_SETTINGS?????
SELECT * FROM USER_PLSQL_OBJECT_SETTINGS
web???????????FireFox ????????? Firebug ?????????????????
???????????????????????
??????????????IE????????
???????????????????????
Firebug??FireFox?????????????
1.???????[Tools]-[Preferences]???
2.[Code Editer] - [Line Gutter]???
3.[Show Line Numbers]?????????
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 |