Oracle鏌ヨ琛ㄥ悕鍙婃ā绯婃煡璇
Posted by 楗洅 on 2009骞11鏈13鏃 , No comment
绀轰緥锛
-
SELECT table_name,tablespace_name,TEMPORARY
-
FROM user_tables
-
WHERE table_name LIKE '%PROV%'
鍒嗘瀽锛
銆銆table_name:琛ㄥ悕锛坴archar2(30)锛;
銆銆tablespace_name:瀛樺偍琛ㄥ悕鐨勮〃绌洪棿锛坴archar2锛30锛夛級锛
銆銆temporary:鏄惁涓轰复鏃惰〃锛坴archar2锛1锛夛級銆
銆銆4绉嶉氶厤绗︾殑鍚箟
銆銆% 琛ㄧず闆朵釜鎴栧涓瓧绗
銆銆_ 琛ㄧず鍗曚釜瀛楃
銆銆[] 琛ㄧず鑼冨洿[a-f]鎴栭泦鍚圼abcdef]鐨勪换浣曞崟涓瓧绗
銆銆[^] 琛ㄧず涓嶅睘浜庢寚瀹氳寖鍥寸殑[a-f] 鎴栭泦鍚圼abcdef]鐨勫崟涓瓧绗 閫氬父琛ㄧず[^a-f] or [^abcdef]
Leave a Reply