1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.

Question Posted / sharad kumar

Answers were Sorted based on User's Feedback



A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to c..

Answer / sharad kumar

select manager name,employee name,level
from table_name
start with manager name is null /* optional*/
connect by prior nocycle employee name = manager name
/*Child = Parent */

Is This Answer Correct ?    20 Yes 0 No

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to c..

Answer / sankar

select manager name,employee name,level from table_name
start with manager_name is null/* optional */ connect by prior
no cycle employee name=manager name/*child=parent*/

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what are aggregate and scalar functions? : Sql dba

0 Answers  

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

0 Answers  

Why does %isopen return false for an implicit cursor?

1 Answers  

what is a record in a database ? : Sql dba

0 Answers  

define different types of trigger. : Sql dba

1 Answers  




Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

How do I save the results of sql query in a file?

0 Answers  

What are all ddl commands?

0 Answers  

what is the difference between group by and order by in sql? : Sql dba

0 Answers  

What is sqlca in db2?

0 Answers  

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

What is embedded sql with example?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories