Home » Other » Training & Certification » basic help (oracle 8)
basic help [message #353364] Mon, 13 October 2008 10:39 Go to previous message
ravi25k
Messages: 2
Registered: October 2008
Junior Member
i am a 12 grade student and my teacher gave me 50 query as home work and i am not able to solve 2 query on default emp table. hope you guys will help me.

1)list the employee name and commission and if the employee dous not earn commission put "no commission" label the column comm.

2)list the employee name,hiredate and salary review date, which is the first Monday after six months of service. label the column REVIEW. Format the dates to appear in the format similar to Sunday. The seventh of September 1981.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Oracle 9i Exam
Next Topic: Peoplesoft and JD Edwards Training (merged)
Goto Forum:
  


Current Time: Fri Apr 19 09:26:23 CDT 2024