You can directly paste the following query from ejb into TOAD
" insert into UMS_USER_MESSAGE (COMPANY_CODE,STATION_CODE, "+
" MESSAGE_TYPE,CHASER_CODE,CHASER_SENT_DATE,SUBJECT,MESSAGE_CONTENT) "+ " values(?,?,?,?,to_date(?,'dd-mon-yyyy hh24:mi:ss'),?,?) "
Then, all you need to do is press
TOAD will automatically remove the 'plus' and the 'quotes' signs at the edges of the above strings.
The converted string will look like this:
insert into UMS_USER_MESSAGE (COMPANY_CODE,STATION_CODE,
MESSAGE_TYPE,CHASER_CODE,CHASER_SENT_DATE,SUBJECT,MESSAGE_CONTENT)
values(?,?,?,?,to_date(?,'dd-mon-yyyy hh24:mi:ss'),?,?)
This would help when you try to test a query in TOAD
Friday, February 22, 2008
How can you use Java query strings in TOAD !
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment