finance_teacher
asked on
ORACLE -- "SQL Developer" View Query ?
Attached 1.jpg shows that I could click
"View/Edit Query" ICON in TOAD to display a
SELECT statement with all "CUSTOMER_ORDER_TAB"
table columns.
How can I do this same thing in the
attached 2.jpg "Oracle SQL Developer" ?
Basically I want to get a SELECT statement
with all "CUSTOMER_ORDER_TAB" table columns.
1.jpg
2.jpg
"View/Edit Query" ICON in TOAD to display a
SELECT statement with all "CUSTOMER_ORDER_TAB"
table columns.
How can I do this same thing in the
attached 2.jpg "Oracle SQL Developer" ?
Basically I want to get a SELECT statement
with all "CUSTOMER_ORDER_TAB" table columns.
1.jpg
2.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Follow the steps below
Dual-View.bmp
Dual-View.bmp
Drag Table to a SQL Worksheet
Dual-Drag.bmp
Dual-Drag.bmp
Choose your drag option
Drag-Options-Box.bmp
Drag-Options-Box.bmp
There you have it
Dual-Select.bmp
Dual-Select.bmp
In you standard tool bar, click on new and select sql window.
temp.JPG