Interested to Buy Any Domain ? << Click Here >> for more details...
pls explain connect by prior with example and its real time
use
- 3 Answers
- 14649 Views
- I also Faced
- E-Mail Answers
Answer Posted / muhammed zaheer
Connect by prior can be used to create heirarchical tree
structure
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How to enter a new row into a table interactively?
what is the scenario where you take the database to NoArchivelog mode?
How to add a new column to an existing table with a default value?
Can we write dml statement in function in oracle?
What is the use of aggregate functions in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
State the difference between a primary key and foreign key?
Query to retrieve record for a many to many relationship ?
Explain the use of log option in exp command.
What is the relation of a user account and a schema in oracle?
What are the ansi data types supported in oracle?
What is an oracle recycle bin?
What is the recommended interval at which to run statspack snapshots, and why?
How to do a full database export?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
