ÈçÏÂ2ÕÅ±í£º
table1:
node_id
parent_id
root_id
value
table2:
node_id
status
±í1´æ´¢ÁËÒ»¿ÃÊ÷£¬±í2´æ´¢Á˽ڵã״̬£¬ÎÊÌâÈçÏ£º
ÈçºÎÓÃSQLÓï¾ä»ñµÃ״̬statusΪ1µÄ½ÚµãµÄËùÓÐ×Ó½ÚµãÒÔ¼°ÆäÏÂ×ÓÊ÷ÖÐËùÓнڵãµÄvalue£¿
Çó½â¡£ÓÉÓڿ͹ÛÒòËØÖ»ÄÜÓÃsqlʵÏÖ£¬²»È»¾ÍµÝ¹éÁË¡£¡£¡£¶àл´ó¼Ò
select a.node_id,a.value ......
rt
¾«Í¨ORACLE 10G PL/SQL ±à³Ì
9i10g±à³ÌÒÕÊõ
»¹ÓбðµÄÂð
ORACLE 9i&10g±à³ÌÒÕÊõ
¡¶Oracle Database 10g PL/SQL³ÌÐòÉè¼Æ¡·
Oracle Database 10g PL/SQL Programming
ÃÀ£ºScott Urman/Ron Hardman/Michael McLaughlin Öø
Åíçõ Òë¡£
Ç廪´óѧ³ö°æÉç¡£¶¨¼Û85£¬»¹´øÀý×ÓÔ´Âë¹âÅÌ~~~~
¡¶¾« ......
OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐÊ²Ã´Çø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
ÒýÓÃ
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
¹þ¹þ ¿ñÀÇÐÖÔÚʲôµØ·½¿´µ½ORACLE½¨ÒéʹÓÃcon ......
ÎÒÓõÄÊÇÀàËÆ¶¯Ò׵ĹÜÀíϵͳ£¨ºÍ¶¯Ò׷dz£Ï󣩣¬ÏµÍ³ÒÔǰûÓÐÉóºË¹¦ÄÜ£¬ÊÇÎÒ×Ô¼º¼ÓµÄ£¬ÔËÐл¹ËãÕý³££¬µ«Õâ¸öÆÀÂÛͳ¼ÆÀ§ÈÅÁËÎҺü¸ÌìÁË£¡ÎÒÏ£ÍûÄÜÔÚϵͳÖмӸö±êÇ©£¬ÒÔÏÔʾÉÏÃæµÄ½á¹û¡£Èç¹ûºÜÂé·³£¬ÄÄÅÂÓÃÖ±½ÓµÄÓï¾ä£¬Ö»Òª°ÑÕâÁ½´Î²éѯµÄ½á¹ûÔÚÎÄÕÂID¶ÔÓ¦µÄÍøÒ³ÉÏÏÔʾ³öÀ´Ò²¿ÉÒÔ£¬ÎÒ¶ÔaspÖÆ×÷¼¸ºõ²»¶®£¬¸÷λ¸ßÊÖÄÜ·ñ´Í½Ì£¬Ð»Ð ......
СµÜÎÒÕý×ö±ÏÒµÉè¼Æ£¬ÏÖÔÚÏëÔÚÍøÒ³ÖÐÉèÖÃÒ»¸öÏÂÀ²Ëµ¥ ³öÏÖ <¹úÄÚ> <¹úÍâ>Á½¸öÏÂÀÑ¡Ïî Ñ¡ÔñºóµãÌá½»°´Å¥£¬Êý¾Ý¿â×Ô¶¯É¸Ñ¡³öÓÐ¹Ø <¹úÄÚ>/ <¹úÍâ>µÄÐÅÏ¢ ÇëÎÊÎÒ¸ÃÈçºÎ×ö£¿
СµÜÓõÄÊÇvbscript
µÚÒ»´ÎÀ´Õâ ûÓзָø´ó¼Ò£¬ÇëÁ½â
°¥~ÔõôûÈ˻ظ´ÄØ
ajax
......
ÔÚÏÂÓиösqlÓï¾äÊÇÈ¡µÃ½á¹ûµãÊýµÄ¡£
¼ÆË㷽ʽÈçÏ£º
, ISNULL(MAX(CASE TEES.EvalEmpType WHEN 0 THEN TER.EvalPoint END) * 0.2
+ MAX(CASE TEES.EvalEmpType WHEN 3 THEN TER.EvalPoint END) * 0.4
+ (CASE
......