About me:Oracle ACE,optimistic,passionate and harmonious. Focus on oracle programming,peformance tuning,db design, j2ee,Linux/AIX,web2.0 tech,etc
全部博文(148)
分类: Oracle
2020-08-31 15:39:15
DROP TABLE t;
CREATE TABLE t AS SELECT * from dba_objects;
dingjun123@ORADB> SELECT COUNT(*),
COUNT(DISTINCT owner) FROM t;
COUNT(*) COUNT(DISTINCTOWNER)
---------- --------------------
76422 35
CREATE TABLE bitmap_test(ID NUMBER,status NUMBER); |