 |
 |
Archives of the TeradataForum
Message Posted: Tue, 11 Jul 2006 @ 23:12:46 GMT
| Subj: | | Re: Replacement of Oracle Cursors in Teradata??. |
| |
| From: | | Theiss, Clifford |
| | Many people use cursors for everything in Oracle, especially very large volumes of update work. | |
| | You should rarely use these types of cursors in Teradata as you would use them in Oracle. | |
| | I would turn almost every cursor into SQL and only use the cursors and other looping functions in Stored Procedures for application logic
control, SQL error checking and validation, etc... | |
Agreed, but I would also add that this is a good rule of thumb for Oracle as well. Just because "many people use cursors for everything in
Oracle" does not mean it's the correct thing to do. I think many application developers use Stored Procedures because they are more familiar, and
more comfortable, with procedural languages than they are with SQL.
| |
