Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> count(*) and nested tables
Is there a simple SQL query to count the total number of rows in a nested table?
My table was set up as follows.
create or replace type tsd_type as object (
time_msec NUMBER,
value NUMBER);
create type tsd_pair as table of tsd_type;
create table tsd_nested (
timestamp_date DATE,
tsds tsd_pair)
NESTED TABLE tsds STORE AS tsdsnpair;
I would like to know how many total rows are in tsds. Also, can you specify different storage parameters for the nested table and the parent table?
Regards,
Brent Collins
Texas Instruments
IT Services
Received on Sat Dec 06 1997 - 00:00:00 CST