Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select Case When ...

Status
Not open for further replies.
vovan1415

vovan1415

Programmer
Dec 6, 2001
50
US
Please, help...
I know there is a new future in SQL for Oracle 8.1.7
SELECT CASE WHEN...END
I know how to use it for SQL but
can't find examples for PL/SQL...
(i mean
select ...
into var
from )
Thanks
Vladimir

Vovan1415@yahoo.com
 
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Question re: SELECT DISTINCT 1
Replies
6
Views
811
SkipVought
S
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
sa0309
  • Locked
  • Question
Case expression in the WHERE clause of a delete statment
Replies
2
Views
151
carp
carp
DeShaun
  • Locked
  • Question
Having issue with ORA 00920. sql works when run seperately
Replies
3
Views
161
Beilstwh
Beilstwh
kernal
  • Locked
  • Question
Is there any way to write a select statement for distinct when there is a CLOB field? 2
Replies
4
Views
313
john parker
john parker

Part and Inventory Search

Sponsor

Back
Top