Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL statement
hi,
if i do the following statement, the result is instant.
select a.UIN, a.Name, a.Street_Code, a.Block, a.Storey_No, a.Main_Hse, a.Sub_Hse, a.Sex_Code, a.DOB, a.Race_Code, a.Country_of_Birth_Code, a.Bkgrd_Lang_Stream_Code, a.Edn_Code, a.Religion_Code from tb_EASY_RMF a where citizenship_code = '0' and to_number(rpad(dob,8,'0')) <= to_number(to_char(to_date('31/05/1978','DD/MM/YYYY'),'YYYYMMDD')) and Date_New_IC_Issued <= to_date('31/05/1999','DD/MM/YYYY');
but is i add a order by at the end, it seems like hanging there, why? pls help cos, it's urgent. thanks..
select a.UIN, a.Name, a.Street_Code, a.Block, a.Storey_No, a.Main_Hse, a.Sub_Hse, a.Sex_Code, a.DOB, a.Race_Code, a.Country_of_Birth_Code, a.Bkgrd_Lang_Stream_Code, a.Edn_Code, a.Religion_Code from tb_EASY_RMF a where citizenship_code = '0' and to_number(rpad(dob,8,'0')) <= to_number(to_char(to_date('31/05/1978','DD/MM/YYYY'),'YYYYMMDD')) and Date_New_IC_Issued <= to_date('31/05/1999','DD/MM/YYYY') order by Street_Code, Block, Storey_No, Main_hse, Sub_hse;
--
evelyn.
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
Received on Mon May 10 1999 - 21:54:16 CDT
![]() |
![]() |