| Author | Message | ||
     Oka_lila_kosam Junior Artist Username: Oka_lila_kosam Post Number: 266 Registered: 08-2008 Posted From: 65.26.194.96 Rating: N/A |
May be Jodha correct. Mainframes loo select * from table a where a.column1 = :WS-VARIABLE ani vuntundi. WS-VARIABLE is a varible that will be declared in Cobol. if we use this variable in SQLs we will call this variable as Hosttage variable. If we want to say the varible we are using is a number then they may reprsent as ":5". | ||
| Jodhaa Side Hero Username: Jodhaa Post Number: 6265 Registered: 02-2008 Posted From: 208.11.223.20 Rating: N/A |
 No one can make you feel inferior without your permission, remember they are no better | ||
| Maverick Side Hero Username: Maverick Post Number: 6906 Registered: 01-2008 Posted From: 192.146.101.71 Rating: N/A |
bind variable can be string or numeric literal | ||
| Swayamkrushi Junior Artist Username: Swayamkrushi Post Number: 184 Registered: 05-2008 Posted From: 159.145.7.90 Rating: N/A |
":palin" ani kooda pettochu... | ||
| Jodhaa Side Hero Username: Jodhaa Post Number: 6264 Registered: 02-2008 Posted From: 208.11.223.20 Rating: N/A |
yes, if I am not wrong..run time lo value specify cheyyali.. No one can make you feel inferior without your permission, remember they are no better | ||
| Mclovin Side Hero Username: Mclovin Post Number: 9927 Registered: 02-2008 Posted From: 69.45.100.129 Rating: N/A |
ante :5 deggara :6, :7 ye number pettinaa okate naa? In this db, there's always someone watching you!!  | ||
| Swayamkrushi Junior Artist Username: Swayamkrushi Post Number: 183 Registered: 05-2008 Posted From: 159.145.7.90 Rating: N/A |
ya ..adi variable , can be any value assigned at run time annattu gippude toad lo testing chesanu... | ||
| Jodhaa Side Hero Username: Jodhaa Post Number: 6263 Registered: 02-2008 Posted From: 208.11.223.20 Rating: N/A |
:5 Indicate, query uses variables inplace of literals anukonta.. No one can make you feel inferior without your permission, remember they are no better | ||
| Oka_lila_kosam Junior Artist Username: Oka_lila_kosam Post Number: 265 Registered: 08-2008 Posted From: 65.26.194.96 Rating: N/A |
Mamaa, akkada exact gaa number vundaa eminaa varaible vundaaa? ee SQL DB2 loo legacy systmes ( mainframes etc) vaduthunaraaa? | ||
| Jodhaa Side Hero Username: Jodhaa Post Number: 6262 Registered: 02-2008 Posted From: 208.11.223.20 Rating: N/A |
hmm..adhi Bind variable in Oracle.. No one can make you feel inferior without your permission, remember they are no better | ||
| Savage Side Hero Username: Savage Post Number: 3504 Registered: 02-2008 Posted From: 148.129.71.53 Rating: N/A |
It indicates a value which is dynamically assigned to column1 when the query is executed ani anukutunna | ||
| Mass Side Hero Username: Mass Post Number: 4446 Registered: 04-2008 Posted From: 12.168.68.11 Rating: N/A |
DECLARE beerTuple Beers%ROWTYPE; makes variable beerTuple be a record with fields name and manufacture, assuming that the relation has the schema Beers(name, manufacture). The initial value of any variable, regardless of its type, is NULL. We can assign values to variables, using the ":=" operator. The assignment can occur either immediately after the type of the variable is declared, or anywhere in the executable portion of the program. An example: DECLARE a NUMBER := 3; BEGIN a := a + 1; END; >>>>>>>>>>>>. http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.htm l RAJYAM PARTY FAN: RIMBOLA RIMBOLA RIMBOLA | ||
| Mclovin Side Hero Username: Mclovin Post Number: 9923 Registered: 02-2008 Posted From: 69.45.100.129 Rating: N/A |
Nenu cheshe SAS Programming lo ismanti code untadi.. ':' is used to create a macro variable.. antha varaki telsu.. In this db, there's always someone watching you!! | ||
| Megapowerstar Junior Artist Username: Megapowerstar Post Number: 339 Registered: 09-2007 Posted From: 155.201.35.68 Rating: N/A |
naaku oka query review kosam vachindi. dont have access to the client table, i am just providing a sample here... select * from table a where a.column1 = :5 what does the value :5 indicate ? |
