ͿĨOracle——Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle
¡¡¡¡
¡¡¡¡±¾Êé×÷Ϊһ±¾´´×÷Ö®³õ¾Í¶¨Î»ÓÚ¼¼ÊõÓ¦ÓõÄʵ¼ù²Î¿¼Ê飬ËäȻǰǰºóºó´®ÁªÁËOracleÊý¾Ý¿âÖÐÊ®Óà¸ö³£ÓÃÌØÐÔ»ò¹¤¾ß£¬µ«ÔÚÕ½ڵÄÉè¼ÆÉÏÍêÈ«×ñÑÕâÒ»ÀíÄî¡£ÔÚÉæ¼°ÌØÐÔ»ò¹¤¾ßÓ¦ÓõÄÿһ¸öÕ½ڣ¬¾ùÓÐÏà¹ØʵÀýÑÝʾÈçºÎÓ¦Óã¬ËùÓÐʾÀýµÄ×îÖÕÄ¿µÄ£¬¾ÍÊÇÏ£ÍûÔĶÁ±¾ÊéµÄÅóÓÑ£¬Äܹ»½«Ë«ÊÖ½â·Å³öÀ´£¬×ÔÐÅÁé»îµØʹÓÃÊéÖнéÉܵĸ÷ÏîÌØÐԺ͹¤¾ß¡£È«Êé¹²·Ö5²¿·Ö£º³õʼ»¯»·¾³¡¢¼ÓÔØÊý¾Ý¡¢±£»¤Êý¾Ý¡¢´«ÊäÊý¾ÝºÍ»ù´¡²¹³ä¡£
¡¡¡¡±¾ÊéÓïÑÔÉú¶¯ÓÄĬ£¬°¸Àý·á¸»£¬Êµ¼ùÐÔÇ¿£¬ÔÚÕ½ڱàÅźÍÄÚÈÝ×éÖ¯·½Ã棬Ö÷ÒªÃæÏò³õ´Î½Ó´¥OracleÊý¾Ý¿âµÄ¼¼ÊõÈËÔ±£¬ÒÔ¼°¶ÔÊý¾Ý¿â²Ù×÷¸ÐÐËȤµÄ¿ª·¢ÈËÔ±£¬¶ÔÓÚ¾ßÓÐÒ»¶¨¼¼ÊõʵÁ¦µÄÖи߼¶Oracle DBAÒ²ÓÐÒ»¶¨°ïÖú£¬Í¬Ê±±¾ÊéÒ²¿ÉÒÔ×÷Ϊ´óÖÐרԺУÏà¹ØרҵʦÉúµÄ²Î¿¼¹¤¾ßÊéºÍÏà¹ØÅàѵ»ú¹¹µÄÅàѵ½Ì²Ä¡£
ÔÎÄ£¨http://www.miiceic.org.cn/10/1002/200912161550526.asp£©
ÖгÌÔÚÏߣ¨±±¾©£©¿Æ¼¼ÓÐÏÞ¹«Ë¾
ÖйúÐÅÏ¢²úÒµÅàѵÍø
www.miiceic.org.cn
×ÉѯÈÈÏߣº400-7068-123
Ïà¹ØÎĵµ£º
¶ÔÓÚÎÒÃǸÕÈëÃŵÄoracle³õѧÕßÀ´Ëµ£¬Ñ§Ï°sqlÓïÑÔÊÇÈëÃŵĵÚÒ»²½£¬Ãæ¶Ôµ¥ÒýºÅºÍË«ÒýºÅ£¬ÎÒÃÇ¿ÉÄÜ»áÀ§»ó£¬Ê²Ã´Ê±ºòÓõ¥ÒýºÅ£¬Ê²Ã´Ê±ºòÓÃË«ÒýºÅÄØ£¿
µ¥ÒýºÅ------ ֵΪ×Ö·ûºÍÈÕÆÚµÄʱºò Èç 'you' '06-june' »¹ÓÐʹÓÃÁ¬½Ó·û||£¬²åÈë¿Õ¸ñ||' ......
¸üжàÐеIJ½Ö裺
²½Öè¶à£¬µ«Ð§ÂʱȽϸߣº
1¡¢create table ÁÙʱ±í value (select a.id,a.name,b.name,... from table1 a,table2 b where a.id=b.id)
2¡¢É¾³ýtable1ÖеļǼ£¬²»Òªdrop
3¡¢insert into table1 select ÄãÐèÒªµÄ×ֶΠfrom ÁÙʱ±í¡£
select * from tb_ai03
create table tb_ai031 as select * from tb ......
OracleÓû§½âËø
¡¡¡¡Ã¿µ±ÎÒÃÇа²×°ÁËoracleºó,µÚÒ»´ÎÔËÐж¼»á³öÏÖÒ»¸öÓû§±»ËøµÄ´íÎóÌáʾ,´ËʱÐèÒªÎÒÃÇÊÖ¶¯½øÐÐÓû§½âËø,ÏÂÃæÒÔ½âËøscottÓû§ÎªÀý: Ê×ÏÈÔÚÃüÁîÐд°¿ÚÖÐÊäÈë sqlplus sys/sys as sysdba ÕâÀïµÄsysÊÇϵͳÕ˺Å,oracle×Ô´øµÄ,ºóÃæµÄsysÊÇÃÜÂë,Õâ¸öÃÜÂëÔÚÄ㰲װʱÉèÖúõÄ. as sysdba Òâ˼¾ÍÊÇÒÔÕâ¸öÓû§×öΪÊý ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......
³£ÓõÄÊý¾Ý¿â×Ö¶ÎÀàÐÍÈçÏ£º
×Ö¶ÎÀàÐÍ ÖÐÎÄ˵Ã÷ ÏÞÖÆÌõ¼þ ÆäËü˵Ã÷
CHAR ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
VARCHAR2 ¿É±ä³¤¶ÈµÄ×Ö·û´® ×î´ó³¤¶È4000 bytes ¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
NVARCHAR2 ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´® ×î´ó³¤¶È4000 bytes
DATE È ......