如何获取有关用户定义类型的信息? [英] How to get information about a User-Defined Type?

问题描述

为简单起见，PL/SQL通常遵循以下条件:

In simplicity, PL/SQL generally follow the following:

DECLARE 
     Variable declaration
BEGIN 
     Program Execution 
EXCEPTION 
     Exception handling
END;

我对PL/SQL还是很陌生，我正在查看变量声明部分，我想在该部分中找到有关SALES_PRODUCT_TY_LIST的更多信息.

I am quite new to PL/SQL and i am looking at the variable declaration section where i would like to find out more information on SALES_PRODUCT_TY_LIST.

我是否可以查找表来检查SALES_PRODUCT_TY_LIST上的信息，例如从all_tab_cols视图中检出表列信息?

Is there a table i may look up to check on information on SALES_PRODUCT_TY_LIST, such as checking out table column information from all_tab_cols view?

CREATE OR REPLACE PROCEDURE GET_DISCOUNTS
(
  v_have_list SALES_PRODUCT_TY_LIST
)
IS
  QUERY VARCHAR(5000);
...

谢谢.

推荐答案

Oracle数据库具有广泛的数据字典(某些其他DBMS产品称为INFORMATION SCHEMA).您可以在此处找到所有视图. las，除非您已经知道要查找的内容，否则修订后的ToC结构使在11g文档中查找内容变得更加困难，因此

The Oracle database has an extensive data dictionary (what some other DBMS products call the INFORMATION SCHEMA). You can find all the views here. Alas, the revised ToC structure makes it harder to find something in the 11g documentation unless you already know what you're looking for, so use the index instead. 8-)

无论如何，您需要查询的视图是 ALL_TYPES 和 ALL_TYPE_ATTRS .

Anyway, the views you need to query are ALL_TYPES and ALL_TYPE_ATTRS.

这篇关于如何获取有关用户定义类型的信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！