Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Who is this called
<Kurt-Erich.Finger_at_hte-company.de> wrote in message
news:1136966293.585715.70890_at_g49g2000cwa.googlegroups.com...
> Strange that no real term exists for it. I searched the "Oracle
> Database, Application Server, and Collaboration Suite Documentation"
> for "Using Sql to write Sql", however, I found nothing. Google gives
> 150 hits, mostly books.
> Why doesn't Oracle give it a name? Daniel A. Morgan also only calls it
> "it".
> The reason behind: I wanted to find out whether mySQL also has "it".
> But without a name it is difficult to search for it.
> btw
> During my search I found that the pipe sign || works completely
> different within mySQL:
> .....MySQL Server understands the || and && operators to mean logical
> OR and AND, as in the C programming language. In MySQL Server, || and
> OR are synonyms, as are && and AND. Because of this nice syntax, MySQL
> Server doesn't support the standard SQL || operator for string
> concatenation; use CONCAT() instead
>
> Unbelievable, they don't support standard SQL "because of this nice
> syntax, "
>
if your original question was meant to be "what is the '||' operator called?", the answer is 'contatenation operator'. that is 'its' name -- depending of what you meant by 'it' ;-)
++ mcs Received on Wed Jan 11 2006 - 06:13:06 CST