My favorites | Sign in
Logo
                
New issue | Search
for
| Advanced search | Search tips
Issue 190: DB Interface: Explicit fields in SQL statements.
1 person starred this issue and may be notified of changes. Back to list
 
Reported by T.Delenikas, Mar 07, 2009
Ref: 
http://groups.google.com/group/SMSLib/browse_thread/thread/ba23eec1db00b5dd

SQL statements should not be "SELECT *" - they should select the entire 
explicit list of fields.

The "SELECT *" clause creates a problem with Oracle.
Comment 1 by T.Delenikas, Mar 07, 2009
Workaround:

Ref: 
http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/resltset.htm#i1022314

SELECT t.* FROM TABLE t ...

Comment 2 by T.Delenikas, Mar 07, 2009
r1778
Status: Completed
Comment 3 by T.Delenikas, Mar 29, 2009
(No comment was entered for this change.)
Status: Fixed
Sign in to add a comment

Hosted by Google Code