Re: NEWBIE: converting MSSQL to oracle

Comments in-line.

PN wrote:

> VC,
> Part of my problem is that I am new to Oracle programming. Most all
> of the examples I have seen have been of the type you described below.
> They typically use either SQL*plus and print, or DBMS_OUTPUT. Which
> for a production system, does me no good.

I agree that DBMS_OUTPUT doesn't belong on a production system but neither does TOAD. You need to get an appropriate tool or risk a disaster.

>
> My clients need to run these queries via odbc. Personally, I have
> been using TOAD to develop queries.

Why ODBC? Why not a native Oracle connection such as that provided by Crystal Reports, Discoverer, Cognos, Brio, and numerous other products?

There are few things worse than ODBC. It should be the API of last resort.

If your organization has sufficient resources to require Oracle they have sufficient resources to get the right tool for the job.

TOAD is a developer tool that belongs in development; maybe test: But nowhere else.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)