Friday, February 22, 2008

How can you use Java query strings in TOAD !

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

No comments: