OracleÊý¾Ý¿â»ñÈ¡µ±Ç°Óû§Á¬½ÓÊýµÄsqlÓï¾ä
¾ßÌåʵÏÖÈçÏ£º
SQL> select count(*) from v$session #Á¬½ÓÊý
SQL> Select count(*) from v$session where status='ACTIVE'¡¡#²¢·¢Á¬½ÓÊý
SQL> show parameter processes #×î´óÁ¬½Ó
SQL> alter system set processes = value scope = spfile;ÖØÆôÊý¾Ý¿â #ÐÞ¸ÄÁ¬½Ó
Ïà¹ØÎĵµ£º
´øUNION ALLÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂ
1. ¶¨ÒåµÄ²éѯµÄunion all²Ù×÷±ØÐëÔÚ×î¶¥µÈ¼¶£¨²éÑ¯ÖØÐ´ºó£©
2. ÎﻯÊÓͼÈÕÖ¾Ö¸¶¨rowidºÍincluding new values
3. Èç¹û±íÉèÉæ¼°µ½Ò»¸ö´óÁ¿µÄinsert»òÕßÖ±½Ó·¾¶¼ÓÔØ£¬deletes,update£¬Ö¸¶¨sequencea
4. fromÁбí ......
¡¡C:\>sqlplus /nolog
¡¡¡¡SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÈý 1ÔÂ 19 14:46:21 2005
¡¡¡¡Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
¡¡¡¡SQL> connect chanet/chanet@oradb;
¡¡¡¡ÒÑÁ¬½Ó¡£
¡¡¡¡SQL> CREATE TABLE IMAGE_LOB (T_ID VARCHAR2 (5) NOT NULL,T_IMAGE ......
Oracleѧϰ:·ÖÇø±íºÍË÷Òý
http://tech.it168.com/a2009/0609/585/000000585998.shtml
ʲôʱºòʹÓ÷ÖÇø£º
¡¡¡¡1¡¢ ´óÊý¾ÝÁ¿µÄ±í£¬±ÈÈç´óÓÚ2GB¡£Ò»·½Ãæ2GBÎļþ¶ÔÓÚ32λosÊÇÒ»¸öÉÏÏÞ£¬ÁíÍⱸ·Ýʱ¼ä³¤¡£
¡¡¡¡2¡¢ °üÀ¨ÀúÊ·Êý¾ÝµÄ±í£¬±ÈÈç×îеÄÊý¾Ý·ÅÈëµ½×îеķÖÇøÖС£µäÐ͵ÄÀý×Ó£ºÀúÊ·±í£¬Ö»Óе±Ç°Ô·ݵÄÊý¾Ý¿ÉÒÔ±»Ð޸ģ¬ ......
DB2 SQL PL
SQL PLÊÇDB2ËùÖ§³ÖµÄ¹ý³Ì»¯ÓïÑÔ£¬ËüÊÇSQL/PSM±ê×¼µÄÒ»¸ö×Ó¼¯¡£Æä¸ù¾ÝÓ¦Ó÷¶Î§²»Í¬£¬ÓÖ·ÖΪInline SQL PL£¬Embeded SQL PLºÍCompiled SQL PL¡£
Inline SQL PL
ÊÊÓ÷¶Î§£º´¥·¢Æ÷¡¢º¯ÊýºÍ·½·¨£¬Ö§³Ö²¿·ÖSQL PL£¬Ê¹ÓÃʱҪעÒâһЩÏÞÖÆ
Óï·¨¹æÔò£ºBEGIN ATOMIC ... END
Embeded SQL PL
ÊÊÓ÷¶Î§£ºÇ¶Èëʽ£¬Åäº ......
ÔÚiBatis 2.xÖУ¬¿ÉÒÔʹÓÃ$xxxx$Óï·¨ÔÚSQLÖж¨Òå¿É¶¯Ì¬²åÈëµÄSQLÔªËØ¡£¶øÔÚiBatis 3.xÖÐÒѾ·¢ÉúÁ˺ܴó±ä»¯¡£
Ê×ÏÈ£¬Óï·¨±äΪ ${xxxx} ÐÎʽ£»
Æäʵ£¬ÄãҪʹÓõÄSQLÔªËØ±ØÐëÊÇÒ»¸öJava BeanµÄÊôÐÔ£¬Ò²ËµÊÇÊäÈë²ÎÊý±ØÐëΪJava Bean£»ÔÚ˵Ã÷ÎĵµÖÐҲûÓÐ˵Ã÷ÈçºÎÖ±½ÓʹÓÃÒ»¸öStringÀàÐ͵ÄÊäÈë²ÎÊý¡£
ÓÚÊÇ£¬ÎÒÓÃDEBUG·ÖÎöÁËi ......