View Single Post
 
Old July 2nd, 2010, 02:54 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

I haven't programmed with Oracle for ages but I can't believe you need to use dynamic SQL for this simple task. With SQL Server the code would resemble (allowing for Oracle's syntax):
Code:
SELECT :XConst, CLAIMNUMBER FROM TBLVOUCHERS WHERE ROWNUM <=4;
__________________
Joe
http://joe.fawcett.name/