Re: Using Cursors

From: --CELKO-- (jcelko212_at_earthlink.net)
Date: 01/25/05

Next message: Gail Erickson [MS]: "Re: simple ALTER TABLE question"
Previous message: Tom Moreau: "Re: temp table troubles"
In reply to: Jon Waterhouse: "Re: Using Cursors"
Next in thread: galenboyerdev_at_hotpop.com: "Re: Using Cursors"
Reply: galenboyerdev_at_hotpop.com: "Re: Using Cursors"
Messages sorted by: [ date ] [ thread ]

Date: 24 Jan 2005 16:10:54 -0800

>> Cursors are no more an Oracle habit than they are a SQL Server
habit. They
are just as necessary/unnecessary in Oracle as they are in SQL Server.
<<

I have to agree with Dave on that one. Looking at Oracle code at
client sites, I find that it is usually full of cursors. The CONNECT
BY is a hidden cursor and apparently so are other proprietary
constructs that depend on an ordering of the data. I think they really
are a bad habit among Oracle programmers, just like SQL Server
programmers slap IDENTITY columns on tables to avoid natural keys.
Good idea? No. Required? No. Happens a lot? Yep.

Next message: Gail Erickson [MS]: "Re: simple ALTER TABLE question"
Previous message: Tom Moreau: "Re: temp table troubles"
In reply to: Jon Waterhouse: "Re: Using Cursors"
Next in thread: galenboyerdev_at_hotpop.com: "Re: Using Cursors"
Reply: galenboyerdev_at_hotpop.com: "Re: Using Cursors"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Cursor for loops
... Their is a big difference between the way that Oracle and SQL Server ... This is the root reason that Oracle doesn't discourage ... cursors at all and that they are generally discouraged on SQL Server. ...
(microsoft.public.sqlserver.server)
Re: Cursor for loops
... Their is a big difference between the way that Oracle and SQL Server ... This is the root reason that Oracle doesn't discourage ... cursors at all and that they are generally discouraged on SQL Server. ...
(microsoft.public.sqlserver.programming)
Re: Cursor for loops
... Their is a big difference between the way that Oracle and SQL Server ... This is the root reason that Oracle doesn't discourage ... cursors at all and that they are generally discouraged on SQL Server. ...
(microsoft.public.sqlserver.clients)
Re: Cursor with Input parameters
... The best way to do it in Oracle may not be the best way in SQL Server. ... Cursors in SQL Server are slow which is another good reason to avoid cursors ... SQL Server MVP ...
(microsoft.public.sqlserver.programming)
Re: IOT, memory and transaction time
... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
(comp.databases.oracle.misc)