Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄÊý¾Ý²»ÕýÈ·£¬Ö®ºóÿ´Î²åÈëµÄÊý¾Ý¾ùÕýÈ·£¨Ö»ÓÐÔÚOracleÖØÐÂÆô¶¯µÄʱºòÎȶ¨¸´ÏÖ£©¡£
Oracle°æ±¾9i£¬AIXÏ£¬Ð¡°æ±¾9.2.0.1
ÃèÊöµÃ²»Çå³þ£¬
ÕýÈ·µÄºÍ²»ÕýÈ·µÄÊý¾ÝÊÇʲô£¿
Äã˵µÄÁÙʱ±íÊÇÖ¸ÓÃcreate global temporary table....½¨Á¢µÄô?

ËùνµÄÕýÈ·ÊÇ£ºÃ¿Ò³ÎÒ¶¼ÒªÏòÁÙʱ±í²åÈë200ÐÐÊý¾Ý£¬ÊÇͨ¹ýinset into selectµÄ·½Ê½£¬ÆäÖÐselect²¿·Ö°üº¬left join£¬µÚÒ»´ÎÖ´ÐÐʱ£¬²åÈëµÄ²»ÊÇ200ÐУ¬ÒÔºóÿ´ÎÖ´ÐоùÊÇ200ÐС£
ÁÙʱ±íÊÇcreate global temporary table....½¨Á¢µÄ

·ÖÒ³Óï¾äÊÇÈçºÎдµÄ£¬ÌùÒ»ÏÂ
ÁíÍ⣬·ÖÒ³²»Ò»¶¨ÒªÐ´ÁÙʱ±í°¡

ÒýÓÃ

·ÖÒ³Óï¾äÊÇÈçºÎдµÄ£¬ÌùÒ»ÏÂ
ÁíÍ⣬·ÖÒ³²»Ò»¶¨ÒªÐ´ÁÙʱ±í°¡
¶¥Ò»Ï¡£¡£¡£Êǰ¡ ·ÖÒ³¸ÉÂïÒ»¶¨ÒªÐ´ÁÙʱ±í°¡¡£¡£¡£

ÎÒµÄÒµÎñ±È½Ï¸´ÔÓ£¬ÐèÒª´ÓÒ»¸öÁ÷Ë®±íÖаÑÿ¸öÈ˵ÄÁ÷Ë®Êý¾Ý²éѯ³öÀ´£¬ÓÉÓÚÁ÷Ë®±íµÄÊý¾Ý±È½Ï´ó£¬ËùÒÔÏëÁËÒ»¸ö°ì·¨£¬¿¼ÂÇʹÓÃÁÙʱ±í·ÖÒ³´¦Àí£¬²»ÖªµÀÕâÑù˵¥ÉÏÄܲ»ÄÜÀí½â

ÖØÆôÒÔºó£¬È«¾ÖÁÙʱ±í»á×Ô¶¯dropµôµÄ¡£²»ÖªµÀÊDz»ÊÇÕâ¸öÔ­Òò


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

ÇóÒ»sqlÓï¾ä - Oracle / ¿ª·¢

Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
  
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ