回答編集履歴
1
細部の修正
answer
CHANGED
|
@@ -27,7 +27,8 @@
|
|
|
27
27
|
WHERE
|
|
28
28
|
COL.COLUMN_NAME = :colname
|
|
29
29
|
AND COL.TABLE_NAME LIKE :tabname
|
|
30
|
-
|
|
30
|
+
ORDER BY 1,2
|
|
31
|
+
';
|
|
31
32
|
|
|
32
33
|
v_cur_hdl1 := DBMS_SQL.OPEN_CURSOR;
|
|
33
34
|
DBMS_SQL.PARSE(v_cur_hdl1, v_stmt1, DBMS_SQL.NATIVE);
|