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

pl/sql´Ê»ãµ¥Ôª

 
2±êʶ·û¹æÔò
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿ ³£Á¿Ê±£¬Ã¿ÐÐÖ»ÄܵÚÒ»Ò»¸ö±êʶ·û
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿£¬³£Á¿Ê±£¬±êʶ·ûÃû³Æ±ØÐëÒªÒÔ°¢À­²®×Ö·û£¨A~Z,a~z£©¿ªÊ¼£¬²¢ÇÒ×î´ó³¤¶ÈΪ30¸ö×Ö·û¡£Èç¹ûÒÔÆäËû×Ö·û¿ªÊ¼£¬ÄÇô±ØÐëҪʹÓÃË«ÒýºÅÒýס¡£
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿³£Á¿Ê±£¬±êʶ·ûÃû³ÆÖ»ÄÜʹÓ÷ûºÅA~Z,a~z£¬0~9£¬_,$ºÍ#¡£Èç¹ûʹÓÃÆäËû×Ö·û£¬ÄÇô±ØÐëҪʹÓÃË«ÒýºÅÒýס.
µ±Ê¹Óñêʶ·û¶¨Òå±äÁ¿£¬³£Á¿Ê±£¬±êʶ·ûÃû³Æ²»ÄÜʹÓÃOracleµÄ¹Ø¼ü×Ö¡£ÀýÈç²»ÄÜʹÓÃSELECT ,UPDATEµÈ×÷Ϊ±äÁ¿Ãû¡£
Èç¹ûҪʹÓÃOracle¹Ø¼ü×Ö¶¨Òå±äÁ¿£¬³£Á¿ÄÇô±ØÐëʹÓÃË«ÒýºÅÒýס
Îı¾
×¢ÒâµÄµØ·½ ÔÚOracle 10gÖ®ÖÐÈç¹û×Ö·û´®Îı¾°üº¬µ¥ÒýºÅ£¬ÄÇô¼È¿ÉÒÔʹÓÃÔ­Óиñʽ¸³Öµ£¬Ò²¿ÉÒÔʹÓÃÆäËû·Ö¸î·û£¨[]£¬{}£¬<>µÈ£©¸³Öµ¡£ÒªÊ¹ÓÃÉÏÊö·Ö¸ô·ûʱ ²»½öÐèÒªÔÙ·Ö¸ô·ûǰºó¼Óµ¥ÒýºÅ£¬¶øÇÒÐèÒª´øÓÐǰ׺q¡£Ê¾ÀýÈçÏÂ
string_var:=q'[I'm a String , you're a String.]'; 
×¢ÊÍ
µ¥ÐÐ×¢ÊÍÈç
SELECT sai INTO salaryn from emp  --È¡µÃ¹ÍÔ±¹¤×Ê
WHERE empno =emp_id;
¶àÐÐ×¢ÊÍÀýÈç
DECLARE
v_sal emp.sal%TYPE;
BEGIN
/*
*ÒÔÏ´úÂëÓÃÓÚÈ¡µÃ¹ÍÔ±¹¤×Ê
*/
SELECT sal  INTO v_sal from emp
WHERE empno=&no;
dbms_output.put_line(v_sal);
END;
PL/SQL´úÂë±àд¹æÔò
±äÁ¿ÓÃv_×÷Ϊǰ׺
³£Á¿ÓÃc_×÷Ϊǰ׺
Óαê ÓÃ_cursor ×÷Ϊºó׺
ÀýÍâÓà e_×÷Ϊǰ׺
µ±¶¨ÒåPL/SQL±íÀàÐÍʱ£¬½¨ÒéʹÓÃ_table_type×÷Ϊǰ׺
µ±¶¨ÒåPL/SQL±í±äÁ¿Ê± £¬ÓÃ_table×÷Ϊºó׺
ÓÃPL/SQL¼Ç¼ÀàÐÍʱ  ÓÃ_record_type ×÷Ϊºó׺¡¢
ÓÃPL/SQL¼Ç¼±äÁ¿Ê± ÓÃ_record×÷Ϊºó׺


Ïà¹ØÎĵµ£º

SQL·Ö×éÅÅÐò

 
½ñÌìÓöµ½¸öÓÐÒâ˼µÄÎÊÌ⣬ÊÇÒ»¸ö·Ö×éÅÅÐòµÄÎÊÌ⣬²»¹ýÒªÇó·Ö×éºÍ·Ö×é¼äÒ²ÒªÅÅÐò£¬Èç¹ûÕâ¸ö×éÄÚÓÐÒ»ÌõÊý¾ÝÊÇ×î½ü¸üеģ¬ÄÇôÕâÕû¸ö×é¶¼Ó¦¸ÃÅÅÔÚÇ°Ãæ¡£
ÏÂÃæÒÔOracleµÄHRʾÀýSchemaÖеÄemployees±íΪÀý£º
Óï¾ä°´²¿ÃÅ·Ö×飬·Ö×éÖ®¼äµÄÅÅÐòÊÇÕâÑùµÄ£ºÈç¹ûÕû¸ö·Ö×éÖÐÓÐÒ»¸öÔ±¹¤µÄhire_dateÊÇ×îеģ¬ÄÇôÕâ¸ö·Ö×é¾ÍÓ¦ ......

SQL¹ÂÁ¢Óû§½â¾ö·½°¸

 ¡¡  Ö¢×´
¡¡¡¡µ±Äú½«Êý¾Ý¿â±¸·Ý»Ö¸´µ½Áíһ̨·þÎñÆ÷ʱ£¬¿ÉÄÜ»áÓöµ½¹ÂÁ¢Óû§µÄÎÊÌâ¡£SQL Server Áª»ú´ÔÊéÖеĹÂÁ¢Óû§ÒÉÄѽâ´ðÖ÷ÌâÖÐûÓн²Êö½â¾ö´ËÎÊÌâµÄ¾ßÌå²½Öè¡£
¡¡¡¡±¾ÎĽéÉÜÁËÈçºÎ½â¾ö¹ÂÁ¢Óû§ÎÊÌâ¡£
¡¡¡¡×´Ì¬
¡¡¡¡Microsoft ÒѾ­È·ÈÏÕâÊÇÔÚ±¾ÎÄ¿ªÍ·ÁгöµÄ Microsoft ²úÆ·ÖдæÔÚµÄÎÊÌâ¡£
¡¡¡¡¸ü¶àÐÅÏ ......

ÓÃADO¹ÜÀíSQL SERVER £¡

      ÔÚÈí¼þ¿ª·¢ÖУ¬³£³£ÐèҪΪ³ÌÐò½¨Á¢Sql ServerÊý¾Ý¿âµÄÔËÐл·¾³¡£Íê³ÉÈçÔÚSQL ServerÊý¾Ý¿âÖн¨Á¢É豸£¬½¨Á¢Êý¾Ý¿â£¬½¨Á¢±í¸ñ£¬·ÖÅäȨÏ޵ȹ¦ÄÜ£¬ÈçºÎ·½±ãµÄ½¨Á¢Ó¦ÓóÌÐòËùÐèSql Server»·¾³µÄÊý¾Ý¿â»·¾³£¬¶ø²»ÓÃÆô¶¯SQL Enterprise ManagerÄØ£¿
ÏÂÃæÀ´¿´£º 
¡¡¡¡Æô¶¯VB6.0£¬Ð½¨Ò»¸ö¹¤ ......

SQL Server 2005 ·ÖÇø±íʵ¼ù——·ÖÇøÇл»


±¾ÎÄÑÝʾÁË SQL Server 2005 ·ÖÇø±í·ÖÇøÇл»µÄÈýÖÖÐÎʽ£º
1. Çл»·ÖÇø±íµÄÒ»¸ö·ÖÇøµ½ÆÕͨÊý¾Ý±íÖУºPartition to Table£»
2. Çл»ÆÕͨ±íÊý¾Ýµ½·ÖÇø±íµÄÒ»¸ö·ÖÇøÖУºTable to Partition£»
3. Çл»·ÖÇø±íµÄ·ÖÇøµ½ÁíÒ»·ÖÇø±í£ºPartition to Partition¡£
²¢Ö¸³öÁËÔÚ·ÖÇø±í·ÖÇøÇл»¹ý³ÌÖеÄ×¢ÒâÊÂÏî¡£
-- ´´½¨·ÖÇøº¯Ê ......

MS Sql ServerÊý¾Ý¿â·ÖÇø

ʲôÊÇÊý¾Ý¿â·ÖÇø£¿
Êý¾Ý¿â·ÖÇøÊÇÒ»ÖÖ¶Ô±íµÄºáÏò·Ö¸î£¬Sql server 2005ÆóÒµ°æºÍÖ®ºóµÄSql server°æ±¾²ÅÌṩÕâÖÖ¼¼Êõ£¬ÕâÖÖ¶Ô±íµÄºáÏò·Ö¸î²»Í¬ÓÚ2000Öеıí·Ö¸î£¬Ëü¶Ô·ÃÎÊÓû§ÊÇ͸Ã÷µÄ£¬Óû§²¢²»»á¸Ð¾õµÄ±í±»ºáÏò·Ö¸îÁË¡££¨2000ÖеıíºáÏò·Ö¸îÊǽ¨n¸ö±íÀýÈ簴ʱ¼ä½¨±íÿÔÂÒ»¸ö±í£¬±íÃû²»Í¬£¬×îºóÐèÒª×öÒ»¸ö´óÊÓͼ£©
Ϊʲ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ