如何把PLSQl中的oracle表结构以表格形式导出来
1、先查询出用户下的所有表：SELECT
C.COMMENTS AS "中文表名",
B.TABLE_NAME AS "英文表名",
A.COMMENTS AS "中文字段",
B.COLUMN_NAME AS "英文字段",
B.DATA_TYPE AS "数据类型",
B.NULLABLE AS "是否为空"
FROM ALL_COL_COMMENTS A, ALL_TAB_COLUMNS B, ALL_TAB_COMMENTS C
WHERE A.TABLE_NAME IN (SELECT U.TABLE_NAME FROM USER_ALL_TABLES U)
AND A.OWNER = B.OWNER
AND A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND C.TABLE_NAME = A.TABLE_NAME
AND C.OWNER = A.OWNER
AND A.OWNER = 'USE' --（用户名要和自己的对应）
ORDER BY A.TABLE_NAME, B.COLUMN_ID;
2、把查询出的结果导出来，点一下获取最后一页，选中所有数据，右键，导出，CVN格式。
绛旓細瀵煎嚭琛ㄧ粨鏋 1銆佹墦寮pl/sql瀹㈡埛绔(瀵煎嚭鏁版嵁琛ㄧ粨鏋)2銆佸湪宸ュ叿澶撮儴閫夋嫨tools銆媏xport user objects 3銆佸鍑 瀵煎嚭琛ㄦ暟鎹 1銆佸湪plsql澶撮儴閫夋嫨tools銆媏xport tables 2銆佸鍑鸿〃鏁版嵁
绛旓細鍦ㄧ郴缁熺幆澧冨彉閲忎腑閰嶇疆ORACLE_HOME锛岄厤缃洃鍚細D:\Oracle\Instant Client\network\admin 鏂囦欢澶逛笅闈㈢殑tnsnames.ora鍐欏叆瑕佽繛鎺ョ殑搴撳氨瀹屾垚浜嗭紝鍏蜂綋鎿嶄綔姝ラ濡備笅锛1銆佸湪缃戜笂鎼滅储涓嬭浇oracleclient銆2銆佽В鍘嬪畨瑁 oracle瀹㈡埛绔紝閫夋嫨濡傚浘鎵绀虹殑閫夐」瀹夎銆3銆佸畨瑁呭畬鎴愬悗锛屽紑濮嬮厤缃plsql 锛岀偣鍑昏彍鍗曟爮涓婄殑宸ュ叿銆4銆...
绛旓細鏂规硶/姝ラ 1 鐢pl/sql developer瀵煎嚭琛ㄧ殑鏁版嵁鏃舵湁涓夌鏂瑰紡锛Oracle Export锛Sql Insert锛宲l/sql developer 2 鍖哄埆 3 瀵煎嚭鏁版嵁鍒癳xcel鏂囦欢 4 excel鏁版嵁瀵煎叆鍒版暟鎹簱 5 PL/SQL Developer鏄疧racle鏁版嵁搴撲腑鐢ㄤ簬瀵煎叆鎴栧鍑烘暟鎹簱鐨勪富瑕佸伐鍏蜂箣涓锛岃繖閲屼富瑕佷粙缁濡備綍鍒╃敤PL/SQL Developer瀵煎叆鍜屽鍑烘暟鎹簱锛屽苟瀵...
绛旓細plsql杩炴帴oracle鏁版嵁鍙互鎸夊涓嬫楠ゆ搷浣滐細1銆佹墦寮PLSQL Developer瀹㈡埛绔紝杩涘叆鐧诲綍鐣岄潰锛2銆佽緭鍏ョ敤鎴峰悕銆佸瘑鐮佸拰鏁版嵁搴擄紝杩涜鏁版嵁搴撴湇鍔″櫒锛3銆佸緢澶氭椂鍊欙紝涓嶇煡閬撴暟鎹簱鐨勫湴鍧锛屽～鍐欓敊璇悗锛岀櫥褰曚細鎻愮ず閿欒锛4銆佷竴鑸殑鏁版嵁搴撴湇鍔″櫒濉啓鏍煎紡涓烘湇鍔″櫒鐨処P鍦板潃锛屽啀鍔犱笂鈥/鈥濓紝鍐嶅姞涓婃暟鎹簱鍚嶏紝5銆佸鏋滆杩炴帴...
绛旓細3銆佹寜鐓т笅鍥剧殑绗竴鍥炬寚寮曪紝鐐瑰嚮宸ュ叿鈫掗閫夐」寮瑰嚭濡備笅绗簩鍥,鏍规嵁绾㈣壊妗涓殑浣嶇疆浼氬彂鐜颁腑闂存湁涓Oracle涓荤洰褰,鍏朵腑绗憼涓槸Oracle涓荤洰褰,绗憽涓槸Oracle鍙傛暟閰嶇疆淇℃伅鐩綍(闇瑕佷竴涓厤缃枃浠惰矾鍔)锛岃繖鏃PLSQL Developer 4銆佹枃浠惰矾鍔插湴鍧澶嶅埗杩涘幓鍚庯紝浼氱珛鍗冲脊鍑烘彁绀烘洿鏀瑰皢鍦ㄩ噸鍚疨LSQL鍚庢湁鏁,濡備笅鍥炬墍绀虹偣鍑荤‘瀹...
绛旓細1銆佸畨瑁Oracle瀹㈡埛绔 2銆佸湪tnsnames.ora鏂囦欢涓缃繛鎺ユ暟鎹簱鐨勭浉鍏充俊鎭 3銆佸畨瑁呯涓夋柟宸ュ叿plsql developer銆
绛旓細浣跨敤InstantClient锛孭L/SQL Developer杩炴帴Oracle锛堝彲浠ュ湪32浣嶆満鍣ㄤ笂浣跨敤銆佷篃鍙互鍦64浣嶆満鍣ㄤ笂浣跨敤锛夛細•1. 涓嬭浇32浣峅racle InstantClient锛屽苟灞曞紑鍒版煇鐩綍锛屼緥濡侰:\instantclient-basic-nt-11.2.0.2.0锛•2. 灏绯荤粺鐨則nsnames.ora鎷疯礉鍒拌鐩綍涓嬶紱•3. 鍦PLSQL Developer涓缃甇racle...
绛旓細璁剧疆濂藉悗锛屾墦寮銆PL/SQL Developer銆戣緭鍏ョ敤鎴峰悕瀵嗙爜锛岄夋嫨鍒氬垰娣诲姞鐨勬暟鎹簱锛岀偣鍑荤‘瀹氬氨鍙互鎴愬姛杩炴帴杩滅▼鏁版嵁搴撲簡銆傚凡鎴愬姛杩炴帴杩滅▼鏁版嵁搴撱傝繖涓槸C#鍦ㄥ～鍐欒繛鎺ユ暟鎹簱鐨勫瓧绗︿覆銆<add name="statistics" connectionString="Provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(...
绛旓細鏂规硶濡備笅锛氱涓姝ワ細鍦ㄧ敤鎴峰悕鍜屽瘑鐮佸鍒嗗埆濉啓linux涓oracle鐨鐢ㄦ埛鍚嶅拰瀵嗙爜 绗簩姝ワ細鍦ㄦ暟鎹簱鏍忚緭鍏モ漣p:1521/瀹炰緥鈥溿傚鈥192.168.8.58:1521/orcl鈥溿傜涓夋锛氳繛鎺ヤ负鈥漀ormal鈥溿傜偣鍑烩濈‘璁も滃嵆鍙繘琛岃繙绋嬭繛鎺ャ
