Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Selecting a table is creating a select statement?

3309371Sep 7 2016 — edited Sep 7 2016

Hi there,

I am new to Oracle, always used MS SQL Server, I am using Oracle 12.1

I am trying to write a select statement and when selecting the table in the left hand pane and dragging the table across to the query panel it creates a select statement with every column in that table. I only require the table name...

Please can someone advise, is there an setting I can change?

Thanks
This post has been answered by B.Delmée on Sep 7 2016
Jump to Answer

Comments

B.Delmée
Answer

tools/preferences/database/drag&drop

Marked as Answer by 3309371 · Sep 27 2020
1 person found this helpful
3309371

Many Thanks...that fixed the issues....

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 5 2016
Added on Sep 7 2016
#sql-developer
2 comments
140 views