This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Select 1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Select 1" Watch "Select 1" New topic
Author

Select 1

Akhilesh Trivedi
Ranch Hand

Joined: Jun 22, 2005
Posts: 1527
What does



do? What is its use ?


Keep Smiling Always — My life is smoother when running silent. -paul
[FAQs] [Certification Guides] [The Linux Documentation Project]
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

This query creates a cursor which contains one column and as many rows as there are in the table. Value of that column is 1 in all rows.

This is not very useful construct.

I sometimes do use constants in the select clause in more complicated circumstances, eg:

(Note: the order by 2, 3 causes ordering by second and third column of the resultset. It is useful with union operator as there could be ambiguity in column names otherwise.)
 
Consider Paul's rocket mass heater.
 
subject: Select 1