oracle oracle服务器如何从分区表中获取分区列名
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/34508597/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to get partition column name from partition table in oracle server
提问by dubey
I am newbie in oracle and i want to get partition column name form partition name.
same query working in MySQL:
我是 oracle 的新手，我想从分区名称中获取分区列名称。相同的查询在MySQL：
SELECT PARTITION_EXPRESSION FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? limit 1
this query will give me partition column name, same output I want in oracle
此查询将为我提供分区列名称，与我在 oracle 中想要的输出相同
My oracle create table query is look like this
我的 oracle 创建表查询是这样的
CREATE TABLE part_char_date
(emp_no NUMBER(11) , birth_date date , first_name VARCHAR2(100),
last_name VARCHAR2(100) , gender CHAR(1) , hire_date DATE )
PARTITION BY RANGE ( hire_date )
INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
(PARTITION p0 VALUES LESS THAN (TO_DATE('1-1-2007', 'DD-MM-YYYY')),
PARTITION p1 VALUES LESS THAN (TO_DATE('1-1-2008', 'DD-MM-YYYY')),
PARTITION p2 VALUES LESS THAN (TO_DATE('1-7-2009', 'DD-MM-YYYY')),
PARTITION p3 VALUES LESS THAN (TO_DATE('1-1-2010', 'DD-MM-YYYY')) )
now I want get partition column. any one help me
现在我想获取分区列。任何人帮助我
回答by Husqvik
If you mean the partition key column then
如果你的意思是分区键列那么
SELECT OWNER, NAME, OBJECT_TYPE, COLUMN_NAME, COLUMN_POSITION FROM ALL_PART_KEY_COLUMNS WHERE NAME = 'PART_CHAR_DATE';
