SQLÓïÑÔ»ù´¡¿¼ºË(¶þ)(oracle)
2.¸ù¾ÝOracle Êý¾Ý¿âscott ģʽϵÄemp ±íºÍdept ±í£¬Íê³ÉÏÂÁвÙ×÷£º
(1) ²éѯ20ºÅ²¿ÃŵÄËùÓÐÔ±¹¤ÐÅÏ¢£»
(2) ²éѯËùÓй¤ÖÖΪCLERK µÄÔ±¹¤µÄÔ±¹¤ºÅ¡¢Ô±¹¤ÃûºÍ²¿Ãźţ»
(3) ²éѯ½±½ðCOMM ¸ßÓÚ¹¤×ÊSAL µÄÔ±¹¤ÐÅÏ¢£»
(4) ²éѯ½±½ð¸ßÓÚ¹¤×ʵÄ20%µÄÔ±¹¤ÐÅÏ¢£»
(5) ²éѯ10ºÅ²¿ÃÅÖй¤ÖÖΪMANAGER ºÍ20ºÅ²¿ÃÅÖй¤ÖÖΪCLERK µÄÔ±¹¤µÄÐÅÏ¢£»
(6) ²éѯËùÓй«ÖÚ²»ÊÇMANAGER ºÍCLERK £¬ÇÒ¹¤×Ê´óÓÚ»òµÈÓÚ2000µÄÔ±¹¤µÄÏêϸÐÅÏ¢£»
(7) ²éѯÓн±½ðµÄÔ±¹¤µÄ²»Í¬¹¤ÖÖ£»
(8) ²éѯËùÓÐÔ±¹¤¹¤×÷Óë½±½ðµÄºÍ£»
(9) ²éѯûÓн±½ð»ò½±½ðµÍÓÚ100µÄÔ±¹¤ÐÅÏ¢£»
(10)²éѯ¸÷Ôµ¹ÊýµÚ¶þÌìÈëÖ°µÄÔ±¹¤ÐÅÏ¢£»
(11)²éѯ¹¤Áä´óÓÚ»òµÈÓÚ10ÄêµÄÔ±¹¤ÐÅÏ¢£»
(12)²éѯԱ¹¤ÐÅÏ¢£¬ÒªÇóÒÔÊ××Öĸ´óдµÄ·½Ê½ÏÔʾËùÓÐÔ±¹¤µÄÐÕÃû£»
(13)²éѯԱ¹¤ÃûÕýºÃΪ6¸ö×ÖĸµÄÔ±¹¤ÐÅÏ¢£»
(14)²éѯԱ¹¤Ãû×ÖÖв»°üº¬×ÖĸS µÄÔ±¹¤£»
(15)²éѯԱ¹¤ÐÕÃûµÄµÚ¶þ¸ö×ÖĸΪM µÄÔ±¹¤ÐÅÏ¢£»
(16)²éѯËùÓÐÔ±¹¤ÐÕÃûµÄǰÈý¸ö×Ö·û£»
(17)²éѯËùÓÐÔ±¹¤µÄÐÕÃû£¬Èç¹û°üº¬×Öĸs £¬ÔòÓÃS Ìæ»»£»
(18)²éѯԱ¹¤µÄÐÕÃûºÍÈëÖ°ÈÕÆÚ£¬²¢°´ÈëÖ°ÈÕÆÚ´ÓÏȵ½ºó½øÐÐÅÅÐò£»
(19)ÏÔʾËùÓÐÔ±¹¤µÄÐÕÃû¡¢¹¤ÖÖ¡¢¹¤×ʺ;©½ò£¬°´¹¤ÖÖ½µÐòÅÅÐò£¬Èô¹¤ÖÖÏàͬÔò°´¹¤×ÊÉýÐòÅÅÐò£»
(20)ÏÔʾËùÓÐÔ±¹¤µÄÐÕÃû¡¢ÈëÖ°µÄÄê·ÝºÍÔ·ݣ¬°´ÈëÖ°ÈÕÆÚËùÔÚµÄÔ·ÝÅÅÐò£¬ÈôÔ·ÝÏàͬÔò°´ÈëÖ°µÄÄê·ÝÅÅÐò£»
(21)²éѯÔÚ2Ô·ÝÈëÖ°µÄËùÓÐÔ±¹¤ÐÅÏ¢£»
(22)²éѯËùÓÐÔ±¹¤ÈëÖ°ÒÔÀ´µÄ¹¤×÷ÆÚÏÞ£¬ÓÓ**Äê**ÔÂ**ÈÕ”µÄÐÎʽ±íʾ£»
(23)²éѯÖÁÉÙÓÐÒ»¸öÔ±¹¤µÄ²¿ÃÅÐÅÏ¢£»
(24)²éѯ¹¤×ʱÈSMITH Ô±¹¤ ¹¤×ʸߵÄËùÓÐÔ±¹¤ÐÅÏ¢£»
(25)²éѯËùÓÐÔ±¹¤µÄÐÕ
Ïà¹ØÎĵµ£º
ÕÒµ½Ò»¸ö½éÉÜoracle°æ±¾µÄÎÄÕ¡£
http://wapedia.mobi/en/Oracle_Database#3.
¡ö1979: Larry Ellison and friends founded Software Development Laboratories.
¡ö1979: SDL changed its company-name to "Relational Software, Inc." (RSI) and introduced its product Oracle V2 as an early commercially ......
Êý¾Ý×ÖµäÊÇOracle´æ·ÅÓйØÊý¾Ý¿âÐÅÏ¢µÄµØ·½£¬ÆäÓÃ;ÊÇÓÃÀ´ÃèÊöÊý¾ÝµÄ¡£±ÈÈçÒ»¸ö±íµÄ´´½¨ÕßÐÅÏ¢£¬´´½¨Ê±¼äÐÅÏ¢£¬ËùÊô±í¿Õ¼äÐÅÏ¢£¬Óû§·ÃÎÊȨÏÞÐÅÏ¢µÈ¡£µ±Óû§ÔÚ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐвÙ×÷ʱÓöµ½À§ÄѾͿÉÒÔ·ÃÎÊÊý¾Ý×ÖµäÀ´²é¿´ÏêϸµÄÐÅÏ¢¡£
OracleÖеÄÊý¾Ý×ÖµäÓо²Ì¬ºÍ¶¯Ì¬Ö®·Ö¡£¾²Ì¬Êý¾Ý×ÖµäÖ÷ÒªÊÇÔÚÓû§·ÃÎÊÊý¾Ý×Öµäʱ²»»á·¢ ......
±³¾°£ºÏµÍ³ÒªÖ§³Ö¶àÖÖÊý¾Ý¿â£¬Í³Ò»insertµÄʱºò»ñÈ¡×Ô¶¯Ôö³¤ÁеĴ¦Àí·½Ê½
ÎÊÌâ1£ºinsert select·½°¸
sqlserver2000Äܹ»Ê¹ÓÃinsertSql SELECT @@IDENTITY AS 'Identity'µÄ·½Ê½À´»ñµÃ£¬µ«ÊÇmysqlÔòÖ»ÄÜʹÓÃexecuteUpdate(insertSql);
executeQuery('SELECT last_insert_id() ')ÕâÑùµÄ·½Ê½£¬·ñÔò»áÅ׳öÒì³££ºjava.sql.SQ ......
1.ÀûÓÃÏÂÃæµÄ½Å±¾´´½¨BOOK£¬READER ºÍ BORROW ±í£¬²¢Íê³ÉºóÃæµÄÁªÏµ¡£
CREATE TABLE BOOK(
NO CHAR(8) PRIMARY KEY,
TITLE VARCHAR2(50) NOT NULL,
AUTHOR VARCHAR2(20) ,
PUBLISH VARCHAR2(20),
PUB_DA ......
(1)char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨ µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎĿոñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä³¤×Ö·ûÊý¾ÝÔò²»»áÒÔ¿Õ¸ñÌî³ä¡£ text´ ......