SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Group by preserving the order

jeneeshNov 29 2006 — edited Jan 5 2011

Say for eg: my data is like this

--order by col3
col1 col2  col3
1       5     1
1      10    2
2      2      3 
2      5      4
1     15     5
I hav to get o/p as
col1  sum_col2
1       15
2       7
1      15
I have to group by preserving the order
Pls give me suggestions..

jeneesh

Paul M.

What's your Operating System ?

SDCraig

Windows 7 Enterprise

Paul M.

Didn't you have any problems with the installation ? The situation you describe is quite strange...

Please execute following commands, and post results :

C:\>lsnrctl stat

C:\>set ORACLE_SID=XE
C:\>sqlplus / as sysdba

Of course you downloaded and installed the correct version (32/64 bit)...

SDCraig

c\> isnrctl stat

"isnrctl" is not recognized as an internal or external command, operable program or batch file".

c\> set oracle_sid = xe

"c\>"

c\> sqlplus / as sysdba

"SQL*Plus: Release 11.2.0.2.0 Projection on Mon Sep 8 10:26:17 2014

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>"

Paul M.

c\> isnrctl stat

It's lsnrctl, not isnrctl.

SDCraig

c\> lsnrctl stat

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 08-SEP-2014 12:28:18

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CFXXXXXXX.xxxxxxxxxxxx.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error

Paul M.

Answer

Your listener is not running : is OracleXETNSListener service started ?

Marked as Answer by SDCraig · Sep 27 2020

SDCraig

Ok, that worked. Thanks.

Quick question: To get started (importing data and utilizing the oracle text functions - ie, contains, fuzzy, etc.), is the next step to access "get started" from the start button and do all of this through the web GUI? Can all of this be done through SQL developer?

Or should I create another help ticket for this question?

Paul M.

should I create another help ticket for this question?

Please do.

1 - 9

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2011

Added on Nov 29 2006

9 comments

14,083 views

SQL & PL/SQL

Group by preserving the order

Comments

Post Details