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 |
RMAN-08099: specifying standby controlfile for proxy backup
ORA-15130: diskgroup "string" is being dismounted
RMAN-08029: snapshot controlfile name set to default value: string
ORA-38704: Checksum error in flashback database log file header.
ORA-13207: incorrect use of the [string] operator
NZE-29162: Non-FIPS cipher suites being used in FIPS mode.
PLS-00167: keyword BULK is used in a wrong context
ORA-08323: scnmin: close of bias lock failed
ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications
PROT-00011: Failed to open the specified destination cluster registry
ORA-30681: improper value for argument EXTENSIONS_CMD_SET
ORA-00361: cannot remove last log member string for group string