Home » SQL & PL/SQL » SQL & PL/SQL » what a few things mean
what a few things mean [message #248860] Mon, 02 July 2007 08:36 Go to next message
cbriggs
Messages: 4
Registered: July 2007
Junior Member
I am very new to sql, I am working with someone else's sql and I was wondering what an expression like this means:

sd.paramid='" + strIParamid + "' "

any help would be great.
Re: what a few things mean [message #248864 is a reply to message #248860] Mon, 02 July 2007 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing in (Oracle) SQL.
You can find syntax in SQL Reference

Regards
Michel


Re: what a few things mean [message #248890 is a reply to message #248860] Mon, 02 July 2007 10:30 Go to previous messageGo to next message
cbriggs
Messages: 4
Registered: July 2007
Junior Member
I hate to be a bother but here is the block of code I am working with it is saying I am missing a expression.

select stddev_samp(enteredvalue) as stddev from
(select enteredvalue, row_number() over
(order by m1.u_calc_no desc) AS rowcount
from sdidataitem sd, s_sample s1, s_sample s2,
u_melt m1, u_melt m2 where s1.s_sampleid=sd.keyid1
and sd.sdcid='Sample'
and s1.sampletypeid='" + sampletype + "'
and s1.samplestatus in ('Approved','Reported','Completed')
and sd.paramid='" + strIParamid + "'
and sd.paramtype='" + paramtype + "'
and sd.enteredvalue is not null
and s1.s_sampleid <> s2.s_sampleid
and s2.s_sampleid = '" + sampleid + "'
and s1.u_meltid = m1.u_meltid
and s2.u_meltid = m2.u_meltid
and m1.u_alloy_codeid = m2.u_alloy_codeid
and m1.u_calc_no < m2.u_calc_no ) where rowcount<=50

this is just as I see it except for I have removed " before and after each line and + at the end. assume that has something to do with its embeddment in Java.
Re: what a few things mean [message #248893 is a reply to message #248890] Mon, 02 July 2007 10:35 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
+ is the concatenation operator in Java.
There is no relation with SQL, the code is just building a string (which may be a SQL statement).

Regards
Michel
Previous Topic: clob as out parameter
Next Topic: User alias
Goto Forum:
  


Current Time: Sat Dec 10 01:04:33 CST 2016

Total time taken to generate the page: 0.14271 seconds