Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find the employees from EMP table those who
have joined in Monday. (there is a column as hiredate which is
a date column i.e values are like 03-DEC-81)
- 5 Answers
- 10685 Views
- I also Faced
- E-Mail Answers
Answer Posted / pramod
select *
from tbl_employees
where DATENAME(DW,hiredate)='Monday' order by hiredate
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of pl/sql packages?
Explain the the update statement in sql?
What is difference between stored function and application function?
Is it possible to create startup or shutdown trigger for on-schema?
What is triggering circuit?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
How do you declare a constant?
What is audit logout in sql profiler?
What is minus?
What is the location of pre_defined_functions.
Why do we use procedures in sql?
Mention what are different methods to trace the pl/sql code?
How do I add a database to sql?
Why do we use subquery?
Can we use rowid as primary key?
