RE: help on moving data from on table to another

RE: help on moving data from on table to another

 

  

OverKill. Try this.

1 select
2 (select count(*)c95 from TEST)C95,
3 (select count(*)cNT from TEST)CNT,
4* (select count(*)cXP from TEST)CXP, sysdate from dual
SQL> /

C95 CNT CXP SYSDATE
---------- ---------- ---------- ---------
19 19 19 21-OCT-03

1 row selected.

MS Sql Server LazyDBA home page