oracle sql developer subquery capabilities -

wondering if has experience using sql developer , has in sight whether generate subquery, without need type in through the worksheet. somthing similar how access works, great. thanks,

you can this, still have type little bit though.

drag table on query builder.

select columns, including 1 want use in clause/subquery.

optionally uncheck 'output' box in column if don't want in output.

right-click in criteria panel, select 'insert subquery'.

you have new panel top, click on it.

drag subquery table(s) draw area.

build subquery.

run.

i go bit more detail pictures here.