i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.wr

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

Question Posted / guest

1 Answers
6262 Views
Aspire, I also Faced
E-Mail Answers

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that..

Answer / kavitha singh

select year,week,date1,to_char(date1,'Day') day
from
(
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

1 No

Post New Answer

More SQL PLSQL Interview Questions

what is a view? : Sql dba

0 Answers

What is function and procedure?

0 Answers

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers GE,

What is difference between sql and oracle?

0 Answers

What is correlated sub-query?

7 Answers Oracle,

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers

What is sql*loader and what is it used for?

0 Answers

What does cursor do in sql?

0 Answers

Why do we use procedures?

0 Answers

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers

What is the limitation on the block size of pl/sql?

0 Answers

What is the difference between a primary key and a unique key?

0 Answers

For more SQL PLSQL Interview Questions Click Here