wood burning stoves 2.0
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


Win a copy of Head First Android this week in the Android forum!
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: 1576
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: 3717
    
  61

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.)
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Select 1
 
It's not a secret anymore!