|
Replies:
0
-
Pages:
1
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
1
Registered:
1/24/13
|
|
|
|
Effective work with editor?
Posted:
Jan 24, 2013 5:39 AM
|
|
|
Hello,
I can't seem to understand the workflow of editor.
Before toad I used mysql workbench and it had simple editor:
need to run some SQL - create new tab for it.
Toad has this editor but it is somehow hidden in menu (only ctrl+N to create new editor?). And I don't think it is the same as workbench's tab - every editor has its own session to the database.
I don't understand this one session per editor thing.
If I need to try out some SQLs which deals with temporary tables (create and select) I have to delete code in the same editor and paste new code?
Let's say I have two SQLs with temporary table creation and one which joins those temporary tables (3 different SQLs).
In workbench I would make 3 new tabs, paste the code and run it. No matter from which tab I would run the code both temporary tables would be visible to the SQL which joins both temporary tables.
But with Toad I'm struggling:
Every editor has its own session and temporary tables are session based. So if I use 3 editors to run those 3 SQLs the SQL which joins two temporary tables will error out because it will not see those two created temporary tables.
Right now I'm doing it like this:
Open new editor (ctrl+N),
Paste SQL for first temp table - run it,
Delete everything from editor,
Paste SQL for second table - run it,
Delete everything from editor,
Paste SQL for joining temporary tables - run it.
This is far far away from being effective?
I'm I doing something wrong?
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
