Interested to Buy Any Domain ? << Click Here >> for more details...
How to write a procedure for displying the data in a TREE
or (PARENT and CHILD ) relationship , for ex: A is the main
project id, for this project B,C,D are sub tasks(sub
project id's) for B the sub tasks are e,f,g and for c is
h ,i ,j and for d is k,l,m
now i need to display the o/p in a TREE fashion
pls help me ,
thanks in advance
surendra
- 2 Answers
- 7222 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / rv
You can use Select..ConnectBY.. PRIOR clause in Oracle to
generate the data in tree structure. Google for the apt
syntax and usage.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are all ddl commands?
How do I create a sql database?
How to create your own reports in sql developer?
What is PL/SQL Records?
Explain how can you save or place your msg in a table?
How to write html code in pl sql?
differentiate between float and double. : Sql dba
What is the maximum database size for sql express?
Mention what does the hierarchical profiler does?
What is thread join () in threading?
Is record in oracle pl sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is Difference Between Unique and Primary Key Constraints?
What is application trigger?
Does mysql_real_escape_string prevent sql injection?
