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【阅读全文】
该语句只能在oracle下使用,别的数据库还不知道怎么搞。 在left jion别的表时候发现左表有重复的,解决办法如下: 点击(此处)折叠或打开SELECT * FROM res_song t LEFT JOIN ( select songid,songsingerid,singerid from (&nbs【阅读全文】
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【阅读全文】