muhammed zaheer


{ City } bahrain
< Country > india
* Profession * programmer
User No # 13277
Total Questions Posted # 0
Total Answers Posted # 3

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 92
Users Marked my Answers as Wrong # 19
Questions / { muhammed zaheer }
Questions Answers Category Views Company eMail




Answers / { muhammed zaheer }

Question { 13249 }

pls explain connect by prior with example and its real time
use


Answer

Connect by prior can be used to create heirarchical tree
structure

Is This Answer Correct ?    6 Yes 3 No

Question { Yardi, 320792 }

how to find the second highest salary from emp table?


Answer

select max(sal) from emp where sal < (select max(sal) from
emp)

Is This Answer Correct ?    86 Yes 16 No


Question { 4143 }

Is it possible to enter only time value into a column of a
table in sql?


Answer

No,
you can store as (HH24:MI) at form level, also make format
DateTime.
Query by - to_date(HH24:MI)
Also you can use Timestamp - I tied it in Oracle 10g. It
will store date and time


Is This Answer Correct ?    0 Yes 0 No