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 ......
1 ÎÊÌâÃèÊö
oracleÊý¾Ý¿âÔÚ·þÎñÆ÷ÉÏÔËÐÐÕý³££¬µ«ÊDz»ÄÜͨ¹ýÍøÂçÁ¬½Ó£¨¼´Ê¹Óÿͻ§¶Ë²»ÄÜÁ¬½ÓÊý¾Ý¿â£¬ÔÚ·þÎñÆ÷¶ËÕý³££¬Õï¶ÏµÄ³õ²½ÔÒòΪ¼àÌýÆ÷ÎÊÌ⣩¡£ÔÚ·þÎñÆ÷¶ËʹÓÃÒÔÏÂÃüÁ
bash-3.1$ cd $ORACLE_HOME/bin
bash-3.1$ ./lsnrctl
LSNRCTL> status
½á¹û³öÏÖ£º
CONNECT (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=E ......
µ±ÔËÐÐ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
[[ÓдíÎ󣿲»¿ ......
°²×°oralce10g R1(10.1)²½Öè·½·¨£º
µÚÒ»²¿·Ö£º
Ò». Ó²¼þ»·¾³£º
1. RAM£ºÖÁÉÙ512M
2. ½»»»·ÖÇø´óСÖÁÉÙ1G£¨»òÕßÊÇÄÚÔÚµÄ2±¶£©
3./tmpĿ¼ ÖÁÉÙÓÐ400M¿ÕÏпռä
4. oracleÈí¼þ°²×°¿Õ¼äÖÁÉÙÔÚ1.5G--3GÖ®¼ä£¨ÒÀ¾Ý°²×°oracleÀàÐͶø¶¨£©
&nbs ......
¡¡¡¡¿Í»§ÓõÄÊý¾Ý¿âÊÇmysql£¬¶øÑз¢ºÃµÄ²úÆ·Ö§³Öoracle£¬ÎªÁËÈÿͻ§ÌÍÑü°ü£¬ÎÒÃDZØÐë°ÑÊý¾Ý¿â»·¾³´ÓoracleתÏòmysql¡£ÎÒÃÇÔÚת»»µÄ¹ý³ÌÖÐÅöµ½ÁËÏÂÃæÒ»Ð©ÎÊÌ⣬ϣÍûÄܸøÍ¬ÑùÔâÓöµÄͬÈÊÃÇһЩ½è¼ø¡£Èç¹ûÎÒÃÇÔÚ×î³õµÄÉè¼Æ¡¢±àÂë¹ý³ÌÖÐ×¢ÒâÊý¾Ý¿âµÄÒÆÖ²ÐÔ£¬ÕâÖÖÇé¿öÏ¿ÉÒÔÍêÈ«²»ÐèÒª×÷¶îÍ⹤×÷¡£
¡¡¡¡Ò»¡¢Êý¾Ý¿â»·¾³´Óoracleת ......