Home » SQL & PL/SQL » Client Tools » Using SQL developer, how to show more then 1 table at at time ?
Using SQL developer, how to show more then 1 table at at time ? [message #302150] Sun, 24 February 2008 03:26 Go to next message
oraclewannabe
Messages: 26
Registered: January 2008
Junior Member
Hi, everybody

I am able to open more then 1 procedures/functions for editing.

However i am not able to open more then 1 table for seeing the data and columns.

1) how do i open more then 1 table tab in sql developer or i am not allow to do so ?

2) is it possible to see what column is the foreign key of a table in sql developer ?

thanks once again Smile
Re: Using SQL developer, how to show more then 1 table at at time ? [message #302347 is a reply to message #302150] Mon, 25 February 2008 05:26 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
1. I don't think that you can (not the way that you want) You'd need to open multiple worksheets and issue multiple queries.
2. Look at the constraints tab. or even better use the user_constraints and user_cons_columns tables

[Updated on: Mon, 25 February 2008 05:27]

Report message to a moderator

Previous Topic: Toad Error
Next Topic: TOAD
Goto Forum:
  


Current Time: Thu Dec 08 06:23:59 CST 2016

Total time taken to generate the page: 0.08517 seconds