Home » SQL & PL/SQL » SQL & PL/SQL » SQL Expression (Oracle 9i)
SQL Expression [message #401404] Mon, 04 May 2009 11:08 Go to next message
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 #401405 is a reply to message #401404] Mon, 04 May 2009 11:12 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Your answer is just a few clicks beyond the URL below.
http://tahiti.oracle.com
Let us know when you have found your answer.
Re: SQL Expression [message #401406 is a reply to message #401404] Mon, 04 May 2009 11:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The answer is in the topic named... tada... SQL Expression
http://www.orafaq.com/forum/t/144651/102589/

Why didn't you read it before posting?

Regards
Michel
Re: SQL Expression [message #401415 is a reply to message #401406] Mon, 04 May 2009 19:54 Go to previous messageGo to next message
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 #401416 is a reply to message #401404] Mon, 04 May 2009 20:12 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Are you claiming that you could not find a single example
by Reading The Fine Manual below as provided in previous thread?
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions001.htm#sthref2625
Re: SQL Expression [message #401417 is a reply to message #401415] Mon, 04 May 2009 20:17 Go to previous messageGo to next message
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 Go to previous message
BlackSwan
Messages: 25045
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
}
Previous Topic: dbms_job not working
Next Topic: XMLTYPE in Oracle
Goto Forum:
  


Current Time: Wed Dec 07 20:18:56 CST 2016

Total time taken to generate the page: 0.28936 seconds