Answer Posted / priya

select firstname,lastname from hire_date where to_upper
(to_char(hire_date, 'mon')) = 'MON' ;

since hire_date is of date type converting the date to
again of date type is of no use.Need to convert it to
string type and select the month.

How do I run sql?

1092

---

Is a table valued function object?

958

---

What is sql query limit?

904

---

What is left inner join in sql?

978

---

What is query optimization in sql?

933

---

What is the use of sqldataadapter?

906

---

Why stored procedure is faster than query?

946

---

What is the process of copying data from table a to table b?

1030

---

Can I join the same table twice?

991

---

Can we group by two columns in sql?

940

---

What is a constraint?

959

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1536

---

how is myisam table stored? : Sql dba

995

---

What pl/sql package consists of?

1029

---

What packages(if any) has oracle provided for use by developers?

5713

---