Viewing 7 posts - 1 through 7 (of 7 total)
Got solution for this on Oracle forum.
var start_date varchar2(10)
exec :start_date := '2010-01-01'
WITH years AS (
SELECT to_date(:start_date,'YYYY-MM-DD') -1 +level dt
August 30, 2013 at 3:50 am
Thanks for your suggestion.
Somehow i managed to write query in Oracle.
Following is my query.
SELECT ROWNUM rn
August 30, 2013 at 12:28 am
Obviously, COUNT(*) will return u the result faster as it just counts number of rows.
When using count(*) you are just joining the tables & counting number of rows.
While in update...
July 7, 2011 at 2:41 pm
I think you should check your joining condition.
The columns which you are using in joining condition are all indexed or you are joining on non indexed column????
One more thing, Are...
July 7, 2011 at 1:42 pm
Thanks for reply...
It worked out.
But can't we have any other way without using a temp table.
Actually, I wrote one more query it worked out as per my requirement but...
July 7, 2011 at 1:41 pm
July 7, 2011 at 1:29 pm
As someone already mentioned if the column is an indexed spetially if it is cluster index then the LIKE keyword will work faster coz it will directly search from that...
June 24, 2011 at 10:47 am