i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks
i need 1st dd for evry wk
Answer / kavitha singh
select year,week,date1,to_char(date1,'Day') day
select year, week,
next_day( to_date( '04-jan-' || year, 'dd-mon-yyyy' ) + (week-2)*7, 'mon' ) date1
from (select '2011' year, rownum week from all_objects where rownum <= 53 ))
|Is This Answer Correct ?||10 Yes||0 No|
What are code pages ?
Where the integrity constrints are stored in Data Dictionary?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
What are the types of SQL Statement?
What is a mutating table
Do view contain data?
How did you export data from database to excel file.
what is mean by forward declaration and where we'll use it.
what is explain plan?, given an example...
How packaged procedures and functions are called from the following?
What is the Subquery?
Difference between views and materialized views?