write a query that displays every Friday in a year with date?
Answer Posted / colarif
select daten, to_char(daten,'DY') dayn from
( select to_date('31-dec-15') + level daten from dual
connect by level <= 366)
where to_char(daten,'DY') = 'FRI'
and to_char(daten,'YYYY') = 2016;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain the characteristics of oracle dba?
Can we store images in oracle database?
What is the use of oracle?
How do I call oracle stored procedures that take no parameters?
How to install oracle database 10g xe?
How can Oracle users be audited?
How to pass parameters to procedures?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How do you store pictures in a database?
How to load excel data sheet to oracle database
Explain oracle left join with an example?
Explain an integrity constrains?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?