SELECT * FROM EMP where TRIM(TO_CHAR(TRUNC(HIREDATE),'DAY'))=�

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

Question Posted / kiran kumar

Answer Posted / kiran kumar

SELECT * FROM EMP
where TRIM(TO_CHAR(TRUNC(HIREDATE),'DAY'))='SUNDAY'

Is This Answer Correct ?

23 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is difference between cursor and trigger?

1079

How does cross join work?

960

What are the different operators available in sql?

1001

Why do we use partitions in sql?

1051

What is the difference between a database and a relational database?

1103

Can you join views in sql?

956

What is server name sql?

1148

Does google use sql?

966

How to change the order of columns in Oracle SQL Plus ?

1058

Why plvtab is considered as the easiest way to access the pl/sql table?

1216

Define SQL and state the differences between SQL and other conventional programming Languages?

1218

What is the difference between in and between in sql?

1062

How to Declare Fixed Length String Value In PL SQL

1156

How do I count rows in sql query?

991

What is the location of pre_defined_functions.

1166