Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle equivalent for temp table variable

639593May 22 2008 — edited May 23 2008
Can anyone help me regarding this..

sample code

declare @temptable table (fldcaptioncode bigint, fldrownumber bigint identity (1,1))

i have declaration in sqlserver stored procedure,

Is there any equivalent in oracle 10g

Thanks in advance

Regards

Ariff
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2008
Added on May 22 2008
2 comments
3,585 views