Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TajKazi
Posting Yak Master
101 Posts |
 Posted - 2014-12-05 : 01:00:53
|
| can we retrieve data from table type variable as an array in oracle key values..eg. ALTER PROCEDURE prn1( @p_prn as KeyValuePair readonly)-- proc which having parameter table type as parameter AS declare @v_formatted_str varchar(50) BEGIN set @v_formatted_str = v_formatted_str + @p_prn(1)(1) END |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-12-05 : 11:54:38
|
| This is a Microsoft SQL Server forum. You are likely to get faster and better responses at an Oracle forum. |
 |
|
|
TajKazi
Posting Yak Master
101 Posts |
Posted - 2014-12-08 : 00:14:43
|
| actually i need this concept in MS SQL Server... means can we have to use table type variabale as any array |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
table type