Home » SQL & PL/SQL » SQL & PL/SQL » /*+ ALL_ROWS */ (Oracle 10g,windows 7)
/*+ ALL_ROWS */ [message #598667] Wed, 16 October 2013 14:25 Go to next message
thelearner
Messages: 133
Registered: April 2013
Location: INDIA
Senior Member
 
SELECT /*+ ALL_ROWS */ empno, ename, sal, job
  FROM emp
  WHERE empno = 7521;



What is use of the 
 /*+ ALL_ROWS */
?

Please any one explain....


Thanks

The Learner.

Report message to a moderator

Re: /*+ ALL_ROWS */ [message #598673 is a reply to message #598667] Wed, 16 October 2013 14:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when all else fails, Read The Fine Manual

https://sites.google.com/site/oraclepracticals/oracle-sql/all_rows-hint

Report message to a moderator

icon1.gif  Re: /*+ ALL_ROWS */ [message #598683 is a reply to message #598667] Wed, 16 October 2013 15:06 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And in the documentation: Database SQL Reference, scroll down to "Hints" section.

Report message to a moderator

Previous Topic: please improve my script which sends *.csv [with SQL*Plus, SQL, KSH] to customer
Next Topic: Generate XML from PL/SQL proc
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 04:24:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.