SQL Expression [message #401162] |
Fri, 01 May 2009 20:34  |
sharmakranthi
Messages: 14 Registered: February 2009 Location: Bangalore
|
Junior Member |
|
|
1.
A simple comparison condition specifies a comparison with expressions or subquery results.
2.
select * |{[DISTINCT] column|expression [alias],.....}
FROM table;
From the above two statements, i would like to know the meaning of EXPRESSION
|
|
|
|
Re: SQL Expression [message #401166 is a reply to message #401163] |
Fri, 01 May 2009 21:05   |
sharmakranthi
Messages: 14 Registered: February 2009 Location: Bangalore
|
Junior Member |
|
|
Thanks for sharing the link. From that link i had arrived at the below example.
I would like to confirm whether the expression means only INITCAP(last_name)or INITCAP(last_name) & =(operator)
This SET clause has the expression INITCAP(last_name) instead of the quoted string 'Smith':
SET last_name = INITCAP(last_name);
|
|
|
Re: SQL Expression [message #401170 is a reply to message #401162] |
Fri, 01 May 2009 22:51   |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>I would like to confirm whether the expression means....
A valid "expression" does not generate any syntax error.
Feel free to experiment to see for yourself what works & what results in some syntax error.
[Updated on: Fri, 01 May 2009 22:52] Report message to a moderator
|
|
|
Re: SQL Expression [message #401171 is a reply to message #401170] |
Fri, 01 May 2009 23:20   |
sharmakranthi
Messages: 14 Registered: February 2009 Location: Bangalore
|
Junior Member |
|
|
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions001.htm#sthref2625
as per this link the definition of Expression is a combination of one or more values, operators, and SQL functions that evaluates to a value. An expression generally assumes the datatype of its components.
From the above definition, i would like to relate the same to below mentioned code
SET last_name = INITCAP(last_name);
the definition says combination of one or more values, operators, and SQL functions.
So from the above code i can relate definition as,
one or more values means last_name
INITCAP means SQL Function
Operator means = or not?
Please confirm can i consider = as Operator or not?
I would like to know this. Not on any errors.
|
|
|
|
|
|
|
|
Re: SQL Expression [message #401347 is a reply to message #401302] |
Mon, 04 May 2009 03:06   |
sharmakranthi
Messages: 14 Registered: February 2009 Location: Bangalore
|
Junior Member |
|
|
I am thinking somebody to answer for my desire. since u have sent the link and as per the definition given in that-EXPRESSION-is a combination of one or more values, operator and sql functions.
I was in need of confirmation whether i can assume Operator as = in the below mentioned code.
SET last_name = INITCAP(last_name);
Please provide the answer for above question
BlackSwan,
definetly i would the give the meaning of LIFE!
|
|
|
|