RE: CASE statement

2002-01-30 Thread Toepke, Kevin M
Jared et al: Yes, the case statement has made it into 9i. There is the CASE expression that is usable in SQL (and PL/SQL) and two types of CASE statements as part of the PL/SQL language specification. Kevin -Original Message- Sent: Wednesday, January 30, 2002 1:25 AM To: Multiple

Re: CASE statement

2002-01-29 Thread Jared Still
This sounds like a SQL feature that has not made it into the PL/SQL engine as yet. There are a number of statistical functions such as regr_slope and regr_intercept that work in SQL, but not in PL/SQL. They are supposed to be in PL/SQL as of 9i, though I haven't checked myself. One way to