Explain CONNECT BY PRIOR - Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

SQL PLUS

DETAILS

Question: Explain CONNECT BY PRIOR

Answer: Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.

Category	SQL Plus Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8020 users
Added on	8/7/2011
Views	71560
Rate it!

Question: Explain CONNECT BY PRIOR

Answer:

Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Difference between SUBSTR and INSTR	View Answer
	Explain UNION, MINUS, UNION ALL and INTERSECT	View Answer
	What is ROWID	View Answer
	What is the fastest way of accessing a row in a table?	View Answer
	What is an integrity constraint	View Answer
	What is referential integrity constraint	View Answer
	What is the usage of SAVEPOINTS	View Answer
	What is ON DELETE CASCADE	View Answer
	What are the data types allowed in a table	View Answer
	What is difference between CHAR and VARCHAR2?	View Answer
	What is the maximum SIZE allowed for each type	View Answer
	How many LONG columns are allowed in a table	View Answer
	Is it possible to use LONG columns in WHERE clause or ORDER BY	View Answer
	What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint	View Answer
	Where the integrity constraints are stored in data dictionary	View Answer
	How will you activate/deactivate integrity constraints	View Answer
	If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE	View Answer
	What is a database link	View Answer
	How to access the current value and next value from a sequence	View Answer
	Is it possible to access the current value in a session before accessing next value	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Plus Interview Questions & Answers - Exam Mode / Learning Mode