Ä£ºý²éѯoracleÖÐÓжàÉÙÕÅ±í£¿ - Oracle / ·Ç¼¼ÊõÇø

Ä£ºý²éѯoracleÖÐÓжàÉÙÕÅ±í£¿

---

select * from tabs;

---

select count(*) from tabs;

---

select sum(1) from all_all_tables;

---

select count(1) from dba_tales;
SELECT COUNT(1) from DBA_OBJECTS WHERE OBJECT_TYPE='TABLE';

---

SQL code:

SQL> select count(*) from user_tables;

COUNT(*)
----------
150

---

select count(*) from tabs ²éѯµ±Ç°Óû§ÏµıíÊýÁ¿
select count(*) from dba_tables »òÕß all_tables ²éѯϵͳÏÂËùÓбíÊýÁ¿

---

select count(TNAME) from tab where TTYPE='TABLE'
Óû§Ï»¹ÓÐÊÓͼ£¬Í¬Ãû´Ê£¡

---

---

End_rbody_65103119//-->
¸Ã»Ø¸´ÓÚ2010-04-30 16:04:58±»¹ÜÀíԱɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP