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

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ËùÓа汾»ã×Ü

ÕÒµ½Ò»¸ö½éÉÜ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 Êý¾Ý×ÖµädzÎö

Êý¾Ý×ÖµäÊÇOracle´æ·ÅÓйØÊý¾Ý¿âÐÅÏ¢µÄµØ·½£¬ÆäÓÃ;ÊÇÓÃÀ´ÃèÊöÊý¾ÝµÄ¡£±ÈÈçÒ»¸ö±íµÄ´´½¨ÕßÐÅÏ¢£¬´´½¨Ê±¼äÐÅÏ¢£¬ËùÊô±í¿Õ¼äÐÅÏ¢£¬Óû§·ÃÎÊȨÏÞÐÅÏ¢µÈ¡£µ±Óû§ÔÚ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐвÙ×÷ʱÓöµ½À§ÄѾͿÉÒÔ·ÃÎÊÊý¾Ý×ÖµäÀ´²é¿´ÏêϸµÄÐÅÏ¢¡£
OracleÖеÄÊý¾Ý×ÖµäÓо²Ì¬ºÍ¶¯Ì¬Ö®·Ö¡£¾²Ì¬Êý¾Ý×ÖµäÖ÷ÒªÊÇÔÚÓû§·ÃÎÊÊý¾Ý×Öµäʱ²»»á·¢ ......

sql server2005 jdbc½â¾ö×Ô¶¯Ôö³¤ÁÐͳһ´¦ÀíÎÊÌâ

±³¾°£ºÏµÍ³ÒªÖ§³Ö¶àÖÖÊý¾Ý¿â£¬Í³Ò»insertµÄʱºò»ñÈ¡×Ô¶¯Ôö³¤ÁеĴ¦Àí·½Ê½
ÎÊÌâ1£ºinsert select·½°¸
sqlserver2000Äܹ»Ê¹ÓÃinsertSql SELECT @@IDENTITY AS 'Identity'µÄ·½Ê½À´»ñµÃ£¬µ«ÊÇmysqlÔòÖ»ÄÜʹÓÃexecuteUpdate(insertSql);
executeQuery('SELECT last_insert_id() ')ÕâÑùµÄ·½Ê½£¬·ñÔò»áÅ׳öÒì³££ºjava.sql.SQ ......

SQLÓïÑÔ»ù´¡¿¼ºË(Ò»)(oracle)

 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 ......

SQL SERVER Ò×»ìÏýµÄÊý¾ÝÀàÐÍ

 (1)char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨ µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎĿոñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä³¤×Ö·ûÊý¾ÝÔò²»»áÒÔ¿Õ¸ñÌî³ä¡£ text´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ