Home » SQL & PL/SQL » SQL & PL/SQL » Iteration function in the select statement
Iteration function in the select statement [message #21477] Tue, 06 August 2002 19:32 Go to next message
Rick
Messages: 49
Registered: March 2000
Member
I am looking to choose a value to be returned in my select statement based on the result of a select value???

Report message to a moderator

Re: Iteration function in the select statement [message #21483 is a reply to message #21477] Wed, 07 August 2002 05:30 Go to previous messageGo to next message
ram
Messages: 95
Registered: November 2000
Member
use sub queries...

select..............where =(select........)

Report message to a moderator

Re: Iteration function in the select statement [message #21487 is a reply to message #21477] Wed, 07 August 2002 07:47 Go to previous message
Su
Messages: 154
Registered: April 2002
Senior Member
You can use DECODE in your SELECT statement.

Report message to a moderator

Previous Topic: Import and export tables resets sequences. Why?
Next Topic: oracle max function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 03:52:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.