CARDINALITY
来源:互联网 发布:au录音软件 编辑:程序博客网 时间:2024/05/20 07:57
语法:
CARDINALITY(nested_table)
作用:
返回nested_table的元素的个数。如果nested_table是空的,或者是null集合,则返回null。
参数:
nested_table是一个嵌套表。
例子:
CREATE OR REPLACE TYPE address_table
AS TABLE OF VARCHAR2(30 CHAR) NOT NULL;
/
CREATE TABLE addresses
(address_id INTEGER NOT NULL
,street_address ADDRESS_TABLE )
NESTED TABLE street_address
STORE AS nested_street_address;
insert into addresses
values(1, address_table('AAA','BBB','CCC'));
commit;
select cardinality(street_address) from addresses;
CARDINALITY(STREET_ADDRESS)
---------------------------
3
- CARDINALITY
- CARDINALITY
- Cardinality
- Cardinality
- Cardinality
- Cardinality
- LCM Cardinality
- UVA10892LCM Cardinality
- 终级Hint:CARDINALITY
- Uva10892 LCM Cardinality
- what is Cardinality?
- Oracle Database Cardinality Feedback
- UVa:10892 LCM Cardinality
- UVA10892 LCM Cardinality(gcd)
- UVA 10892-LCM Cardinality
- UVa 10892 - LCM Cardinality
- oracle的cardinality feedback
- mysql cardinality 索引选择
- GridView的编辑用法
- 大三的寒假Silverlight之旅 1
- SOAOffice2010:企业内部在线Office史上的里程碑
- GSTREAMER SMALL
- 关于Tomcat的 The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found o
- CARDINALITY
- IP地址和MAC地址
- 科翰软件:Office中间件行业的领导者
- 新手上路
- 在linux/unix下,你是怎么中止一个java进程的?
- instances
- MD5码
- 随机选择行的SQL语句? ORACLE SQLSERVER ECT.
- 春节将至