Home » SQL & PL/SQL » SQL & PL/SQL » using values of dynamic sql
using values of dynamic sql [message #35978] Sun, 28 October 2001 04:17 Go to next message
JRW
Messages: 8
Registered: October 2001
Junior Member
How can I use the same value more than once in a dynamic sql statement while using the "using" clause without duplicating it ?.

open for 'select a1, a2, a3
from a
where a1 = :b1 and a2 = :b2 and a3 = :b3'
using 'TT','TT','TT' --<< want to avoid using this same value over and over

thanks

----------------------------------------------------------------------

Report message to a moderator

Re: using values of dynamic sql [message #35990 is a reply to message #35978] Mon, 29 October 2001 07:13 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
open for 'select a1, a2, a3
from a
where a1 = :b1 and a2 = :b1 and a3 = :b1'
using 'TT';

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: ALTER keyword in SP
Next Topic: updating a huge database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 15:05:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.