<div>
<div class="content wysiwyg-content">
I am trying to perform a Roll Up in Toad for Oracle to produce results like this: 
 
BEACH_NAMES &nbsp; &nbsp;BEACH_NAMES_CNT 
- ---------- 
0 &nbsp; &nbsp; &nbsp; &nbsp;103 
1 &nbsp; &nbsp; &nbsp; &nbsp; 87 
2 &nbsp; &nbsp; &nbsp; &nbsp; 71 
3 &nbsp; &nbsp; &nbsp; &nbsp; 52 
4 &nbsp; &nbsp; &nbsp; &nbsp; 88 
5 &nbsp; &nbsp; &nbsp; &nbsp;113 
6 &nbsp; &nbsp; &nbsp; &nbsp;163 
7 &nbsp; &nbsp; &nbsp; &nbsp;412 
8 &nbsp; &nbsp; &nbsp; &nbsp;537 
9 &nbsp; &nbsp; &nbsp; &nbsp;592 
&nbsp; &nbsp; &nbsp; &nbsp; 2218 
 
Using this Query: 
 
SELECT SUBSTR(BEACH_NAMES,1,1) BEACH_NAMES, COUNT(*) BEACH_NAMES_CNT FROM &nbsp;BEACH_SEC_INFO GROUP BY ROLLUP SUBSTR(BEACH_NAMES,1,1)); 
 
I am getting a syntax error, I spend most of my time in SQL Server. &nbsp;I have access to multiple instances and perhaps I need to include DBO?
</div>
</div>

I am trying to perform a Roll Up in Toad for Oracle to produce results like this:

BEACH_NAMES    BEACH_NAMES_CNT
- ----------
0        103
1         87
2         71
3         52
4         88
5        113
6        163
7        412
8        537
9        592
        2218

Using this Query: 

SELECT SUBSTR(BEACH_NAMES,1,1) BEACH_NAMES, COUNT(*) BEACH_NAMES_CNT FROM  BEACH_SEC_INFO GROUP BY ROLLUP SUBSTR(BEACH_NAMES,1,1));

I am getting a syntax error, I spend most of my time in SQL Server.  I have access to multiple instances and perhaps I need to include DBO?

Oracle Roll Up Syntax Error

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.