oracle sequenceÖµÖØÖûØ1
declare
n number(10);
tsql varchar2(100);
begin
select test_seq.nextval into n from dual;
n:=-(n-1);
tsql:='alter sequence test_seq increment by'|| n;
execute immediate tsql;
select test_seq.nextval into n from dual;
tsql:='alter sequence test_seq increment by 1';
execute immediate tsql;
end;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ORACLE´¥·¢LGWRÈÕ־д½ø³ÌµÄÌõ¼þ
µ±Ä³¸öÊÂÎñÌύʱ
µ±ÖØ×öÈÕÖ¾»º³åÇøÖб仯µÄ¼Ç¼³¬¹ý1MBʱ
µ±ÖØ×öÈÕÖ¾»º³åÇøÖÐËù´æµÄ¼Ç¼Òѳ¬¹ý»º³åÇøÈÝÁ¿µÄ1/3
ÔÚDBWR½«Êý¾Ý¿â¸ßËÙ»º³åÇøÖÐÐ޸ĹýµÄÊý¾Ý¿éдµ½Êý¾ÝÎļþ֮ǰ
ÿ3ÃëÖÓ
......
¹ÊÕϽâ¾ö£ºoracle10g Êý¾Ý¿â¸´ÖÆÍ¬²½
ºÇºÇ¡£oracleÎÒÊǸö²ËÄñ£¬Ã»»¨¹¦·òÑо¿Ëü£¬µ«ÎÒ»¹ÊǼæÈÎdba£¬Ä¿Ç°oracleÈ«²¿ÊÇÓÉÒÔǰµÄdba´´½¨µÄ£¬oracleȷʵºÃ¡£»ù±¾Ã»Óгö¹ýÎÊÌ⣬ÎÒÒ²¾Í»ù±¾²»¹ÜËüÁË£¬¿ÉÊÇÓÉÓÚ×Ô¼º´ÖÐÄ´óÒ⣬ÔÚÒ»´ÎÐ޸ķþÎñÆ÷µØÖ·Ê±ºò£¬Êý¾Ý¿âÀïµÄtns...Õâ¸öÅäÖÃÎļþÍüÁËÐ޸쬽á¹ûµ¼ÖÂͬ²½Ê§°Ü£¬µÈÎÒ·¢ÏÖµÄʱºò£¬ ......
ʹÓÃÊý¾Ý¿âÊÓͼͨ³£³öÓÚÒÔÏÂÁ½¸öÄ¿µÄ£º1¡£½µµÍ²Ù×÷¸´ÔÓ¶È£»ÊÓͼÊÇÔ¤±àÒëµÄ²éѯ²Ù×÷£¬Ò»´Î¶¨Ò壬֮ºó¿É¿ìËÙµ÷Óã»2¡£Ìá¸ßϵͳ°²È«¡£ÊÓͼ×÷ΪÊý¾Ý¿â¶ÔÏ󣬿ÉÒÔ½«ÆäȨÏÞ¶ÀÁ¢³öÀ´¸³¸øÓû§£¬¿É±ÜÃâÓû§¶Ô»ù±íµÄäĿΣÏÕ²Ù×÷£¬Í¬Ê±Ò²¿ÉÆÁ±ÎÒ»²¿·Ö˽ÃܵÄÊôÐÔÁС£
¶¨ÒåÓï¾ä£º
CREATE
[OR REPLACE
]
[FORCE
|NOFORCE
......
µ±ÔËÐÐsqlplus.shµÄʱºò±¨³ö£º
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
ºÜÆæ¹Ö
nls_lang.shµÄ114ÐÐǰºóÊÇÕâÑùµÄ
if [[ -n "$LC_ALL" ]]; then
locale=$LC_ALL
elif [[ -n "$LANG" ]]; then
locale=$LANG
else
locale=
fi
[[ÓдíÎ󣿲»¿ ......