select ename from emp where trim(to_char(Hiredate,'day')) =

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

Question Posted / kavitha nedigunta

15 Answers
41195 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / kavitha nedigunta

select ename
from emp
where trim(to_char(Hiredate,'day')) ='monday'

Is This Answer Correct ?

19 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is scalar data type in pl sql?

1075

Does view contain data?

1040

Can we join 3 tables in sql?

1049

what is clause? : Sql dba

1066

What are the types of join and explain each?

1054

what is an extent ? : Sql dba

1107

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1137

What is dialect in sql?

954

what is online transaction processing (oltp)? : Sql dba

1000

What is normalisation and its types?

1012

What do you mean by dbms? What are its different types?

1021

Which command is used to delete a package?

1179

What is loop in pl sql?

1041

What are different types of keys?

1109

what is union? : Sql dba

1033