Home » Other » Client Tools » TOAD , multiple SELECT COUNT(*) fail
TOAD , multiple SELECT COUNT(*) fail [message #286973] Mon, 10 December 2007 14:42 Go to next message
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 #286974 is a reply to message #286973] Mon, 10 December 2007 14:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is an Oracle forum.

Regards
Michel
Re: TOAD , multiple SELECT COUNT(*) fail [message #286975 is a reply to message #286973] Mon, 10 December 2007 14:48 Go to previous messageGo to next message
icm63
Messages: 22
Registered: December 2007
Junior Member
I know that I am just trying to do this PLSQL in Orcale, and I am using a MSSQL /TSQL example of what I want to do in oracle, so how do I do this in PLSQL or Taod SQl window ?
Re: TOAD , multiple SELECT COUNT(*) fail [message #286978 is a reply to message #286975] Mon, 10 December 2007 14:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Different RDBMS, different syntax.
Just read SQL Reference and search here this has been asked less than a week ago.

Regards
Michel
Re: TOAD , multiple SELECT COUNT(*) fail [message #286980 is a reply to message #286973] Mon, 10 December 2007 15:02 Go to previous messageGo to next message
icm63
Messages: 22
Registered: December 2007
Junior Member
Thanks for the very useful link, however its like finding a needle in a haystack. I search GO, nothing...
Re: TOAD , multiple SELECT COUNT(*) fail [message #286981 is a reply to message #286973] Mon, 10 December 2007 15:03 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
try replacing go with ;
Re: TOAD , multiple SELECT COUNT(*) fail [message #286986 is a reply to message #286981] Mon, 10 December 2007 15:20 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why do you keep mentioning "PL/SQL"? Those counts are to be done using SQL. Moreover, your problem has nothing to do with Oracle; it is just the fact that you don't know how to use TOAD.
Re: TOAD , multiple SELECT COUNT(*) fail [message #286993 is a reply to message #286973] Mon, 10 December 2007 16:45 Go to previous messageGo to next message
icm63
Messages: 22
Registered: December 2007
Junior Member
yes I am learning TOAD, hence this is a newbie forum.

And no this ';' does not work. So I guess issue will stay unresloved, I was just hoping for a little help.
Re: TOAD , multiple SELECT COUNT(*) fail [message #286995 is a reply to message #286973] Mon, 10 December 2007 16:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I was just hoping for a little help.
If you are dissatisfied with the timeliness, correctness, completeness or tenor & tone of the responses, you are entitled to a complete & FULL refund.

Please submit you refund request to dave.null@whiners.com
Re: TOAD , multiple SELECT COUNT(*) fail [message #287025 is a reply to message #286995] Mon, 10 December 2007 23:23 Go to previous messageGo to next message
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.
Re: TOAD , multiple SELECT COUNT(*) fail [message #287076 is a reply to message #286973] Tue, 11 December 2007 01:06 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

select count(1) from VWDIM_TRANSACTION;


Select the above query and press F9. For more help you can read Toad user manual by pressing F1.

Kiran.

[Updated on: Tue, 11 December 2007 01:06]

Report message to a moderator

I like the TOAD application [message #288483 is a reply to message #286973] Mon, 17 December 2007 14:08 Go to previous messageGo to next message
darrinallen
Messages: 2
Registered: December 2007
Junior Member
I really enjoy TOAD
Re: TOAD , multiple SELECT COUNT(*) fail [message #288533 is a reply to message #286973] Mon, 17 December 2007 23:40 Go to previous message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Quote:

I really enjoy TOAD


Enjoy SQL*Plus as well!


Regards,
Kiran.
Previous Topic: Getting error when startup SQL Navigator 3
Next Topic: iSqlPlus problem
Goto Forum:
  


Current Time: Fri Mar 29 03:38:45 CDT 2024