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

What does count (*) do in sql?

951

What are sql commands?

933

Why is %isopen always false for an implicit cursor?

1034

What does desc stand for?

1021

What are pl/sql packages?

1035

How does sql developer connect to oracle database?

949

What is sql injection owasp?

998

What is the difference between partition and index?

921

Can we insert data into materialized view?

896

What are the rules to be applied to nulls whilst doing comparisons?

1270

How do you declare a constant?

909

Explain sql data types?

1033

what are set operators in sql? : Sql dba

982

tell me about various levels of constraint. : Sql dba

989

How insert into statements in sql?

1007