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

oracle biee Óû§·ÃÎÊȨÏÞÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÈçºÎÈò»Í¬Óû§×éϵÄÓû§¿´µ½Ä³¸ö±íµÄ²»Í¬×ֶΣ¬ÒDZíÅÌÒѾ­°ÑËùÓÐ×ֶζ¼ÏÔʾ³öÀ´ÁË£¬ÏÖÔÚÏëÈò»Í¬Óû§µÇ¼½øÈ¥¿´µ½µÄÄÚÈݲ»Ò»Ñù£¬±ÈÈçaÓû§Òª¿´±íµÄc1£¬c2£¬bÓû§Òª¿´Õâ¸ö±íµÄc4£¬c5£¬ÈçºÎÉèÖ㬼±Çó½â£¡
ÊÓͼ....


ÊÇÔÚbieeÀ²»ÊÇoracle°¡


Ïà¹ØÎÊ´ð£º

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

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

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

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

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

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......

OracleµÄDBConsoleÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

СµÜÎÒÕâѧÆÚÔÚѧOracle¡£°²×°ÁËOracle 10.2.0°æ±¾¡£µ«³öÏÖÁËÈçÏÂÎÊÌâ¡£
ORACLEÊý¾Ý¿âµÄORCLÊý¾Ý¿âÄÜͨ¹ýemÀ´¹ÜÀí£¬ÓÐoracleDBConsoleorcl·þÎñ¡£
È»ºóÎÒ×Ô¼ºÐ½¨ÁËÒ»¸öÊý¾Ý¿â¡£·¢ÏÖ·þÎñÀïʲô·þÎñ¶¼ÓУ¬¾ÍÊÇûÓÐor ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ