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
- 10832 Views
- I also Faced
- E-Mail Answers
Answer Posted / siva
Select* from emp where to_char(hiredate,'dy')='mon';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Explain the components of sql?
What are the disadvantages of not performing database normalization?
How do I run a program in pl sql?
What is the difference between stored procedure and view?
how are mysql timestamps seen to a user? : Sql dba
how can you create an empty table from an existing table? : Sql dba
Do stored procedures prevent sql injection?
What are types of indexes in sql?
Is it possible to sort a column using a column alias?
What is sql engine in oracle?
What is a table partition?
Enlist the data types that can be used in pl/sql?
What is difference between stored function and application function?
How do I run pl sql in sql developer?
