|
| Name | Add Nested Tables Tab |
| Rating |  |
| Created On | 24-JUL-08 |
| Category | XM Extensions |
| Database Version | 10.2 |
| Description | This tab will show the Table Name, Column and Data Type:
<items>
<item type="editor" node="TableNode" vertical="true">
<title><![CDATA[Nested Tables]]></title>
<query>
<sql><![CDATA[
SELECT table_name, parent_table_column, table_type_name
FROM user_nested_tables
WHERE upper(parent_table_name) = upper(:OBJECT_NAME)
ORDER BY parent_table_column]]></sql>
</query>
</item>
</items> |
|
|
|
|
| Is very useful | 25-JUL-2008 03:25AM
|
|
|
|