Answer / prasant

SELECT FIRST_NAME,LAST_NAME FROM employees
where TRIM(TO_CHAR(TO_DATE(HIRE_DATE),'DAY'))='MONDAY';

if any issue,contact me.

Answer / kiran kumar

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

Answer / kavitha nedigunta

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

Answer / ajit nayak

SELECT *
FROM EMP
WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDAY';

Answer / nitin umale

SELECT last_name,TO_CHAR(hire_date, 'Day,dd-Mon-yy')Hire_date
FROM employees
WHERE UPPER(TRIM(TO_CHAR(hire_date, 'day')))='MONDAY';

Answer / ajeet

select last_name,to_char(hire_date,'day,mm,yyyy')
from employees
where trim(to_char(Hire_date,'day')) ='monday'

Answer / mahendar reddy

SELECT ENAME FROM EMP WHERE TO_CHAR(TO_DATE(HIREDATE),'D')='2';

IT fetch the employee name who joined on monday
Here
1=sunday
2=monday
--
---
--
--
--etc

Answer / chaitu

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

Answer / emmanuel

Select * from emp
Where to_char(TO_DATE(hire_date),'day')='monday';

Answer / venkat

Select first_name,Last_name
from employees
where To_date('HIREDATE','D')=2;

1-SUNDAY
2-MONDAY
----
7-SATURDAY

The advantage of the above query even don't know about the
format of day of the week We get the output.
Monday,
MON
MONDAY
ETC

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

How can I get the number of records affected by a stored procedure?

0 Answers  

What is the difference between an inner join and an outer join?

0 Answers  

What are the different datatypes available in PL/SQL?

0 Answers  

What is Referential Integrity?

3 Answers  

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

How to call shell script from pl sql procedure?

0 Answers  

What is break?

0 Answers  

How to raise user-defined exception with custom sqlerrm ?

0 Answers  

How do I count rows in sql query?

0 Answers