SQL Expression [message #401404] |
Mon, 04 May 2009 11:08  |
ygsunilkumar
Messages: 100 Registered: August 2008
|
Senior Member |
|
|
Single-Row Functions accepts one or more arguments and return one value for each row returned by the query.
Any argument can be one of the following:
a. user-supplied constant
b. variable value
c. column name
d. expression
From the above definition, I would like to know what is the "expression". If example is provided, it will be easy to understand. Thanks.
|
|
|
|
|
Re: SQL Expression [message #401415 is a reply to message #401406] |
Mon, 04 May 2009 19:54   |
ygsunilkumar
Messages: 100 Registered: August 2008
|
Senior Member |
|
|
Michel, before posting I read the topic SQL Expression
but no where the meaning of Expression with the example is provided. So please provide me the meaning with examples. Thanks.
|
|
|
|
Re: SQL Expression [message #401417 is a reply to message #401415] |
Mon, 04 May 2009 20:17   |
dr.s.raghunathan
Messages: 540 Registered: February 2008
|
Senior Member |
|
|
hi,
i also thought expression means the cine actor who express the feelngs in the face. Just a joke. It is more or less equivalent to formula like a + b * c. Though everyone knew the answer, some strange simple question will confuse anybody. For example, a spider was scrolling through his eight legs. Suddently someone asked the spider, everyday and whenever you move, which leg you are moving first step. Thereafter, whenever it intend to move it tried to watch his step. Infact that thinking itself collapsed.
I know many people will bounce back with what is the example relevance to orafaq. Still, i entertain myself through replying.
yours
dr.s.raghunathan
|
|
|
Re: SQL Expression [message #401420 is a reply to message #401404] |
Mon, 04 May 2009 20:59  |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
Which type of expression do you care about the most?
{ simple_expression
| compound_expression
| case_expression
| cursor_expression
| datetime_expression
| function_expression
| interval_expression
| object_access_expression
| scalar_subquery_expression
| model_expression
| type_constructor_expression
| variable_expression
}
|
|
|