ORACLE查询空表

数据库中有100以上个表，如何用一条语句查询出没有数据的表。MSSQL又有什么方法。追加100分。非会勿答。

Oracle版本
-------------------------------------------
DECLARE
v_table tabs.table_name%TYPE;
v_sql VARCHAR2(888);
v_q NUMBER;
CURSOR c1 IS
SELECT table_name tn FROM tabs;
TYPE c IS REF CURSOR;
c2 c;
BEGIN
DBMS_OUTPUT.PUT_LINE('以下为空数据表的表名:');
FOR r1 IN c1 LOOP
v_table :=r1.tn;
v_sql :='SELECT count(*) q FROM '||v_table||' where rownum = 1';
OPEN c2 FOR v_sql;
LOOP
FETCH c2 INTO v_q;
EXIT WHEN c2%NOTFOUND;
IF v_q=0 THEN
DBMS_OUTPUT.PUT_LINE(v_table);
END IF;
END LOOP;
CLOSE c2;
END LOOP;
EXCEPTION
WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Error occurred');
END;



MSSQL版本
-------------------------------------------------------------
alter PROCEDURE [dbo].[GET_EMP_DTL] AS
declare @tb_name nvarchar(200)
declare @sql nvarchar(2000)
declare @sql1 NVARCHAR(2000)
DECLARE @count NVARCHAR(10)

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[#TB_TB_DTL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[#TB_TB_DTL]
CREATE TABLE dbo.#TB_TB_DTL (
table_name NVARCHAR(200))

declare cur_getdtl scroll cursor
for
Select Name FROM sysobjects WHERE xtype = 'U'order by NAME
open cur_getdtl
fetch first from cur_getdtl into @tb_name
while (@@fetch_status <> -1)
BEGIN
SET @sql1 = 'SELECT '+ @count +'=cast(COUNT(*) as char(10)) FROM '+@tb_name
execute sp_executesql @sql1
PRINT @count

IF @count = '0'
set @sql = 'insert into #TB_TB_DTL values('''+@tb_name+''')'
execute sp_executesql @sql
fetch next from cur_getdtl into @tb_name
end
close cur_getdtl
DEALLOCATE cur_getdtl

select * from #TB_TB_DTL
GO

--运行---
EXEC dbo.GET_EMP_DTL