When I have 6 values for any column, in select statement I get display of 6 rows selected while if I - Even though you have 5 values for one column you won't get display of "5 rows selected" because by default the empty value taken as 'null' into the table. So the row contains 'null' value is also considered for displaying "6 rows selected". - SQL In Oracle Interview Questions and Answers

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 IN ORACLE

DETAILS

Question: When I have 6 values for any column, in select statement I get display of 6 rows selected while if I have 5 values for one column i don't get display of 5 rows selected, how to get that display?

Answer: Even though you have 5 values for one column you won't get display of "5 rows selected" because by default the empty value taken as 'null' into the table. So the row contains 'null' value is also considered for displaying "6 rows selected".

Category	SQL In Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9698 users
Added on	11/22/2013
Views	69713
Rate it!

Question: When I have 6 values for any column, in select statement I get display of 6 rows selected while if I have 5 values for one column i don't get display of 5 rows selected, how to get that display?

Answer:

Even though you have 5 values for one column you won't get display of "5 rows selected" because by default the empty value taken as 'null' into the table. So the row contains 'null' value is also considered for displaying "6 rows selected". Source: CoolInterview.com

Answered by: lakshmikish | Date: 12/23/2008 |

Contact lakshmikish

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
	table name stud,a mark 23,b mark 87,c mark 75,d mark 34; write the query to find 2nd highest mark in stud table?	View Answer
	Whet are the difference between primary key and foreign key?	View Answer
	What are various joins used while writing SUBQUERIES?	View Answer
	What are various constraints used in SQL?	View Answer
	What are different Oracle database objects?	View Answer
	What is difference between Rename and Alias?	View Answer
	What is a view?	View Answer
	What are various privileges that a user can grant to another user?	View Answer
	What is difference between UNIQUE and PRIMARY KEY constraints?	View Answer
	Can a primary key contain more than one columns?	View Answer
	How you will avoid duplicating records in a query?	View Answer
	What is difference between SQL and SQL*PLUS?	View Answer
	Which datatype is used for storing graphics and images?	View Answer
	How will you delete duplicating rows from a base table?	View Answer
	What is difference between SUBSTR and INSTR?	View Answer
	There is a string 120000 12 0 .125 , how you will find the position of the decimal place?	View Answer
	There is a % sign in one field of a column. What will be the query to find it?	View Answer
	When do you use WHERE clause and when do you use HAVING clause?	View Answer
	Which is more faster - IN or EXISTS?	View Answer
	What is a OUTER JOIN?	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 In Oracle Interview Questions & Answers - Exam Mode / Learning Mode