Interested to Buy Any Domain ? << Click Here >> for more details...
write a query that displays every Friday in a year with date?
- 5 Answers
- 6532 Views
- Flipkart, HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / ranjan
SELECT C_DATE, TO_CHAR(C_DATE,'DY')
FROM
(
SELECT TO_DATE('01-JAN-2016','DD-MON-YYYY')+LEVEL-1 C_DATE
FROM DUAL
CONNECT BY LEVEL <= (SYSDATE - TO_DATE('01-JAN-2016','DD-MON-YYYY')+1)
)
WHERE TO_CHAR(C_DATE,'DY') = 'FRI'
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Explain database link?
How can I create database in oracle?
Describe varray?
Can multiple columns be used in group by in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to export your own schema?
what are steps for interface? where is exchange rate defined in which table?
What are the general rules on data consistency?
How do you tell what your machine name is and what is its IP address?
How to count groups returned with the group by clause in oracle?
What are the differences between lov and list item?
What is an oracle database table?
Explain oracle’s system global area (sga).
