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

What is the process of debugging?

0 Answers  

---

What are sql*plus environment variables?

0 Answers  

---

How many rows will return from dual table?

4 Answers   Fujitsu,

---

what are the advantages of sql ? : Sql dba

0 Answers  

---

What do you understand by case manipulation functions?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

How is data stored in sql?

0 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

Explain the savepoint statement.

0 Answers  

---

What is a sql statement?

0 Answers  

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---