listen
Oracle 鏁 鏁 嵁鍒 嗙 墖鎶 € € Chain? / Span> 滆 € €? # Xff1a; 佹 佹 婚>: http://liulee.myrice.com
Oracle 鍏 徃鍑 扇 镄凮 Racle Enterprise 8.0.5 浠ュ叾浼 樿 秺 镄勬 € ц 兘鍗 兘鍗 缑 缑 缑 嗗 澶 х 敤鎴 敤鎴 殑闱 掔潗
瀹冧 瀹冧 涓 板 瘜镄 勫 唴 宓 屽 嚱鏁? # XFF0C; PL / SQL 鏀 寔, 澶 澶 鍙? # XFF0C; Application Server board 垚 垚? # XFF0C; 缁椤 紑鍙 戜 汉 樻 樻彁?
嗘瀬 澶 х 殑鐏 椿 镐 с €?
鍦 | r 镄勭敤 镄勭敤 潈闄 潈闄 愬 垎 閰 閰 閰, ㄣ 佸嚱 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁 鏁, 鏁,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
SELECT, DELETE, EXECUTE 绛夋 搷 搷? # Xff0c; 骞 骞 湭 鎻 愪 緵 楁 楁 绾 х х 冮檺 璁 璁 璁 (瀹 台 台 涓? # Xff0c; 瀵 瀵 ぇ鍨 嬫 暟鎹 簱杩涜 楁 楁 绾 х 殑 殑
鏉冮檺 璁 璁 铏 铏 铏 劧 "潵 潵 嗗畨 鍏ㄦ € ф 闱 ㈢ 殑濂 , 嗗 庢 庢 € ц 兘镄 勫 瓨 鍦 ㄤ 竴 瀹 殑 殑 褰 搷 搷), 锲犳 , 瀵 簬澶 у у у
MIS 粺, 杩涜 鏁 鏁 嵁镄 勫 垎 鐗 囨 槸 鍦ㄦ墍闅 鍦ㄦ墍闅 历 镄勩 镄勩 € € 镄勩 镄勩 镄勩 镄勩 镄勩 镄勩 镄勩 槸 镄勩 槸???
€ 鑸 湴, € € 吀鍨 嬬殑 Mis 鏁 鏁 嵁搴 揿 揿 鍙 璁 ° C 槸杩 欐 牱镄? # Xff1a;
瀵 瀵 敤 鎴 潈闄 潈闄 愮殑鍒 嗛 鏄 鏄 € 椂 椂 粺 粺;;;;;;;;;;;;;;;;;;;;;;;;;
1 銆佸 湪 € 佸 佸 垎鐗 囩殑? Customer ? # Xff0c; 濡 GRANT_NUM NUMBER (20) 鍙婃 墍灞 儴闂? Sunit_id varchar (10) ,
2 銆佸 ヨ 〃 〃 鍒涘 锷ㄦ € € 锲? Customer_PV
Select * from Customer A
Where cd_warehouse.sUnit_id is null
OR exisss
Select * from customer b where a.sUnit_id = b.sUnit_id
And (b.sgrant_num> = to_number (Substr (useerenv ('client_info'), 1, 10))
AND (b.sgrant_num <= to_number (substr (useerenv ('client_info'), 11, 10)))))
3 銆佸 湪 鐢 ㄦ 埛 锏 綍 綍 粺 粺 镞 镞 镞 鏀;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
4 銆佽 umbrella? # Xff0c; 瀵 瀵 璁 ¤ € € # xff0c; 嶅瓨 鍦ㄥ 垎 鐗 棶棰 棶棰? # XFF0C; 瀵 渶缁 渶缁 堢? # XFF0C; 鍙 畾涔 鐢ㄦ 埛 镄 勭 粍 缁 垎鐗 垎鐗 垎鐗 佛 鏉 ョ 鏉 熻 鐢ㄦ 埛鑳 埛鑳 ?????? ? ? ? ? ? ?
铡熺 悊锲?
浼樼 偣:
1 銆佺 敱 敱 嶅姟 鍣 ㄨ 嚜 锷 ㄥ 畲鎴? # XFF0C; 瀵 瀵 璁 ° C 棤浠 綍褰 綍褰 搷;
2 銆侀 € 熷 蹇? # XFF0C; 瀵 瀵 法 阅 鎹 棤鏄 庢 樉 褰 褰 搷;
缂 缂 偣:
1 銆佸 彧 鑳 牴鎹 牴鎹 ? # Xff08; 鎴栧 叾浠? # Xff09; 杩涜 绾 绾 鍒 鍒 嗙墖 嗙墖 嗙墖;;;;;
2 銆佹 妧 妧 疄鐜 疄鐜 鏉? # XFF0C; Terrux 镄勬 洿 鏀 鏀 皢鐩 帴褰 搷 搷 嗗浘 嗗浘 (Dark € 侀 侀 侀 鏂 敓鎴 敓鎴? # Xff09 ;;
3 銆佷 竴镞 ︾ 粍缁 囨 満 鏋勫 彉鍖? # Xff0c; 鍒椤垎 鐗 鐗 渶 侀 侀 侀 鏂 缃 € €?