質問編集履歴
1
回答内容をもとにsqlを修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -188,11 +188,29 @@
|
|
|
188
188
|
|
|
189
189
|
-- テーブル一覧取得クエリ（getTblName.batから呼び出し想定）
|
|
190
190
|
|
|
191
|
+
SET ECHO OFF
|
|
192
|
+
|
|
193
|
+
SET FEEDBACK OFF
|
|
194
|
+
|
|
195
|
+
SET PAGESIZE 50000
|
|
196
|
+
|
|
197
|
+
SET TERMOUT OFF
|
|
198
|
+
|
|
199
|
+
SET TRIMSPOOL ON
|
|
200
|
+
|
|
201
|
+
SET SERVEROUTPUT ON SIZE UNLIMITED FORMAT WRAPPED
|
|
202
|
+
|
|
203
|
+
SPOOL list_table_name.log
|
|
204
|
+
|
|
191
205
|
SELECT TABLE_NAME
|
|
192
206
|
|
|
193
|
-
FROM
|
|
207
|
+
FROM USER_TABLES
|
|
208
|
+
|
|
194
|
-
|
|
209
|
+
WHERE DROPPED = 'NO' -- Oracle10g以降はWindowsでいうゴミ箱機能が追加されたので条件の追加が必要
|
|
210
|
+
|
|
195
|
-
ORDER BY TABLE_NAME
|
|
211
|
+
ORDER BY TABLE_NAME;
|
|
212
|
+
|
|
213
|
+
SPOOL OFF
|
|
196
214
|
|
|
197
215
|
```
|
|
198
216
|
|
|
@@ -202,11 +220,31 @@
|
|
|
202
220
|
|
|
203
221
|
-- ビュー一覧取得クエリ（getViewName.batから呼び出し想定）
|
|
204
222
|
|
|
223
|
+
SET ECHO OFF
|
|
224
|
+
|
|
225
|
+
SET FEEDBACK OFF
|
|
226
|
+
|
|
227
|
+
SET PAGESIZE 50000
|
|
228
|
+
|
|
229
|
+
SET TERMOUT OFF
|
|
230
|
+
|
|
231
|
+
SET TRIMSPOOL ON
|
|
232
|
+
|
|
233
|
+
SET SERVEROUTPUT ON SIZE UNLIMITED FORMAT WRAPPED
|
|
234
|
+
|
|
235
|
+
SPOOL list_table_name.log
|
|
236
|
+
|
|
205
237
|
SELECT VIEW_NAME
|
|
206
238
|
|
|
207
239
|
FROM USER_VIEWS
|
|
208
240
|
|
|
241
|
+
WHERE DROPPED = 'NO' -- Oracle10g以降はWindowsでいうゴミ箱機能が追加されたので条件の追加が必要
|
|
242
|
+
|
|
209
|
-
ORDER BY VIEW_NAME
|
|
243
|
+
ORDER BY VIEW_NAME;
|
|
244
|
+
|
|
245
|
+
SPOOL OFF
|
|
246
|
+
|
|
247
|
+
|
|
210
248
|
|
|
211
249
|
```
|
|
212
250
|
|