Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 41506 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / arun kumar reddy
select * from
(select emp.*,to_char(to_date(hiredate),'day') as join_day from emp)
where join_day like'mo%';
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is update query?
What are pl/sql cursors?
Differentiate between % rowtype and type record.
Why are cursors used?
What is cursor explain with example?
Is stored procedure faster than query?
Mention what does the hierarchical profiler does?
what is a foreign key ? : Sql dba
What is a join?
What are the two types of periodical indexes?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is t-sql? : Transact sql
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is sql rowcount?
