aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 1511
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: 3433
    
  47

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.)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Select 1
 
Similar Threads
html text box issues
Strange JDBC PreparedStatements Problem
MySQL equivalent to Oracle's "select * from dual;"
issue to pass the dynamic value in query
SQL Current Time