Oracle 嬬殑 鏁 嵁鍒 嗙 墖鎶 € € 痏 痏? 9cbs 鍗 鍗 

zhaozj2021-02-11  186

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; 鍒椤垎 鐗 鐗 渶 侀 侀 侀 鏂   缃 € €?