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

FROM...

Thanks for your suggestion.

Somehow i managed to write query in Oracle.

Following is my query.

WITH years AS (

SELECT ROWNUM rn

FROM dual

...

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...

Hi,

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...

Thanks for reply...

It worked out.

But can't we have any other way without using a temp table.

If possible..

Actually, I wrote one more query it worked out as per my requirement but...

Hi,

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...

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...