SQL> create or replace procedure sp_pro7(goodsnum char) is 2 v_category goods.category%type; 3 begin 4 select category into v_category from goods where goodsid=goodsnum; 5 if v_category='家具' then 6 update goods set unitprice=unitprice-10【阅读全文】
The following INIT.ORA/SPFILE parameter can be used if your current
redologs are corrupted or blown away. It may also be handy if you do
database recovery and one of the archived log files are missing and
cannot be restored.
NOTE: Caution is advised when enabling this parameter as you might【阅读全文】
Beginning
with Oracle10G, when statistics are gathered for a table, the old statistics are
retained so should there be any problem with performance of queries dependent
on those statistics, the old ones can be restored.How
long does Oracle retain the statistics for ?
The
default peri【阅读全文】
Total System Global Area 1065353216 bytesFixed Size 2089336 bytesVariable Size 486542984 bytesDatabase Buffers 570425344 bytesRedo Buffers 6295552 bytesDatabase mounted.Database opened.SQL> select count(*) from user$ u, obj$ o 2 where【阅读全文】