select ename,to_char(hiredate,'Day') from emp where trim( to

Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)

Question Posted / chaitu

Answer Posted / chaitu

select ename,to_char(hiredate,'Day') from emp
where trim( to_char(hiredate,'Day'))='Monday'

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why coalesce is used in sql?

982

Explain about various levels of constraint.

922

What is number function in sql?

944

What are the different set operators available in sql?

1009

Is sql the best database?

957

What does select count (*) mean in sql?

1005

What are pl/sql cursor exceptions?

1077

What is the difference between sum and count in sql?

973

How do you add a column to a table?

1039

What is the difference between join and natural join?

915

What are pl sql procedures?

1014

What is sql select statement?

1014

How do you optimize a stored procedure query?

984

Define union, minus, union all, intersect ?

986

Mention what is the use of function "module procedure" in pl/sql?

1038