display details of employee's who are seniour to there own
manager ? ( In a Emp Table )
Answers were Sorted based on User's Feedback
Answer / jyothi
select e.ename,e.hiredate,m.ename,m.hiredate from emp e,emp m
where e.mgr=m.empno
and e.hiredate<m.hiredate
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
SELECT * FROM Emp GROUPBY department HAVING dateofbirth >any
(select dateofbirth FROM Emp GROUPBy department);
| Is This Answer Correct ? | 1 Yes | 0 No |
LCD-00112: illegal integer radix specification [string]
ORA-12688: Login failed: the SecurID server rejected the new pincode
PCC-00023: Unable to log off from ORACLE
RMAN-08115: channel string: restoring SPFILE
SQL*Loader-00273: READBUFFERS may be used only in direct path.
ORA-16081: insufficient number of processes for APPLY
PLS-00233: function name used as an exception name in when clause
ORA-14619: resulting List subpartition(s) must contain at least 1 value
ORA-06748: TLI Driver: cannot allocate t_discon
ORA-07801: slbtpd: invalid exponent
O2F-00320: Invalid filename for the OUTTYPE file
ORA-24397: error occured while trying to free connections