|
View previous topic :: View next topic
|
| Author |
Message |
AnuB
Currently Banned
New User
Joined: 29 Aug 2005
Posts: 33
|
|
|
|
| ?How can one determine before performing a task that either a cursor is required or simple select statement ? |
|
| Back to top |
|
 |
baru
New User
Joined: 08 Sep 2005
Posts: 4
Location: Mumbai
|
|
|
|
| It depends upon your requirement. If the SQL Query retrieves only one row you can use simple select and for multiple rows you can use cursor. |
|
| Back to top |
|
|
withnams
New User
Joined: 06 Jul 2005
Posts: 26
Location: Chennai
|
|
|
|
| If the WHERE clause refers to a column that is unique you can avoid cursor. But as baru said it all depends on your requirement. |
|
| Back to top |
|
|
|
|
