SQL Editor

Code completion in UPDATE..SET..FROM

Toad should support code completion in UPDATE..SET..FROM

 

For example, code completion for:

 

UPDATE x

SET foo=123

FROM Bar x

 

should work the same as for:

 

UPDATE Bar

SET foo=123

 

Toad should support code completion for joins in FROM statement:

 

UPDATE x

SET foo=123

FROM Bar x JOIN Bar2 y ON x.id=y.xid

WHERE y.foo2 = 234

Tags

Voting

7 votes
Idea No. 34