Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ugly PL/SQL Code

Re: Ugly PL/SQL Code

From: Jeff <jeff_at_work.com>
Date: Fri, 06 Feb 2004 13:28:13 GMT
Message-ID: <c004pd$4ao$1@cronkite.cc.uga.edu> 





In article <73e20c6c.0402051646.415cf7d4_at_posting.google.com>, wizofoz2k_at_yahoo.com.au (Noons) wrote:



>SELECT 


>tablespace_name as TS,

>substr(file_name,1,21) as FS,

>count(*)

>from dba_data_files

>group by 1,2;




group by tablespace_name, file_name;
Received on Fri Feb 06 2004 - 07:28:13 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US