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 |
ORA-24413: Invalid number of sessions specified
CLSR-00526: Failed to retrieve database configuration in OCR
RMAN-07521: cannot create recovery catalog in database version string; version string required
ORA-02070: database stringstring does not support string in this context
NZE-28839: no persona descriptor
ORA-39129: Object type string not imported. Name conflicts with the master table
NCR-03021: NCRO: Reset the in-band line
ORA-09706: slsget: get_process_stats error.
PLS-00670: sort columns must be simple column names
RMAN-00556: could not open CMDFILE "string"
ORA-31475: redo log catalog contains no metadata for the source table
ORA-07754: slemcf: fwrite failure