| TOAD , multiple SELECT COUNT(*) fail [message #286973] |
Mon, 10 December 2007 14:42  |
icm63
Messages: 22
Registered: December 2007
|
Junior Member |
|
|
HI,
A real newbie question, I have Toad, and I am swing over from MS SQL.
This fails, I place these two count select statements in the same Toad SQL window, hoping to get a quick row count. So what is the PLSQL syntax for this process
SELECT COUNT(*) FROM VWDIM_TRANSACTION
go
SELECT COUNT(*) FROM VWDIM_TRANSACTION_DETAIL
go
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: TOAD , multiple SELECT COUNT(*) fail [message #287025 is a reply to message #286995] |
Mon, 10 December 2007 23:23  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Come on guys, give the OP a break.
He quite clearly states that he is new to Oracle and just came over from the dark side. Giving someone a link to the sql-reference is good, but it's hard to find & combine the little differences between the two daabases.
Instead, the guy gets burnt down; I wonder what happened to the heartly and welcoming atmosphere Orafaq used to have...
@icm63: I don't have TOAD myself, so I cannot help you directly (which, by the way isn't normally the way on Orafaq anyway, we usually try to point people in the right direction and help them find the answer themselves)
In TOAD's sql-window there are two options: one to execute a single sql-statement (use ; as separator) and one to execute the complete window as a script.
Since you are new to Oracle, I strongly advise you to first use sqlplus for a while. It may be not as flashy and easy to use as a GUI tool like TOAD, but you will learn where the deviations are between Oracle and SQLServer. If you use a GUI tool, you will be distracted by the GUI-tools anomalies itself.
Once you are comfortable using sqlplus, then you can switch to a GUI.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
