| Burton |
Posted: Feb 11, 2007 08:28:55 PM |
Total Post: 53
Joined: Dec, 2006
|
We had a question that says "write a query to join x_table to y_table and select ..." , I had to go and look at both tables and see where I could make a join.
I had to go and find the PK /FK relationship.
I had to do this to see where constraints were.
Another person in the class mentioned a program named Toad, which he says enables him to see relations easily.
Has anyone here tried this,or any other program with SQL ?
B
|
|
|
 ravisurya |
| Posted: Feb 12, 2007 12:35:50 AM |  |
|
Total Post: 4
Joined: Oct, 2006
|
IF u have the dba priviliges U can see those at below tables
dba_constraints,user_constraints.
|
|
|
|
|
| maddy |
| Posted: Feb 12, 2007 04:37:53 AM | |
|
Total Post: 18
Joined: Aug, 2006
|
Toad is a GUI tool and any how you are at the begining stage first learn through your SQL tool and later you can shift towards using TOAD tool ....
|
|
|
|
|
| Burton |
| Posted: Feb 12, 2007 10:40:06 AM | |
|
Total Post: 53
Joined: Dec, 2006
|
Actually, the Enterprise Manager Console has been pointed out to me and it gives me exactly what I was looking for.
Thanks.
B.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
