Answer / arun kumar reddy

select * from
(select emp.*,to_char(to_date(hiredate),'day') as join_day from emp)
where join_day like'mo%';

Answer / sankarapandian

select *,upper(datename(dw,gedate())) as dayofweek from
employee where upper(Convert(varchar(15),datename dw,gedate
())))='MONDAY'

Answer / mohammad murtuza ali

select firstname,lastname from hire_date where
sdate='Monday'
(or)
select firstname,lastname from hire_date where
sdate='27022010'

Answer / priya

select firstname,lastname from hire_date where to_upper
(to_char(hire_date, 'mon')) = 'MON' ;

since hire_date is of date type converting the date to
again of date type is of no use.Need to convert it to
string type and select the month.

Answer / ravindra

Select first_name,Last_name
from employees
where To_date('Hire_date','Day')='Monday'

How to run sql*plus commands in sql developer?

0 Answers  

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

How to prepare for oracle pl sql certification?

0 Answers  

What is extent clause in table space?

1 Answers   TCS,

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

what are different types of keys in sql?

0 Answers  

how to calculate expressions with sql statements? : Sql dba

0 Answers  

Where is sql database stored?

0 Answers  

How to avoid using cursors?

0 Answers  

Compare SQL and PL/SQL.

3 Answers  

what are all types of user defined functions? : Sql dba

0 Answers