OraFAQ Forum: SQL & PL/SQL » PIVOT - SQL Command not properly ended

Home » SQL & PL/SQL » SQL & PL/SQL » PIVOT - SQL Command not properly ended (TOAD 10.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PIVOT - SQL Command not properly ended [message #609005]

Thu, 27 February 2014 23:44

kupstar
Messages: 16
Registered: November 2013
Location: PNG

Junior Member

Hi experts,
Can someone make my following query work? I am running the query on Toad 10.6 and I am running into the error 'SQL Command not properly ended'. I am not sure what is wrong with my script.

SELECT *
FROM (SELECT employee#, paytype, sum(amt) amt FROM pehistpay GROUP BY employee#, paytype)
PIVOT (sum(amt) FOR paytype IN ('S','A','T','D','B'));

Thankyou in advance.
Kupstar

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609006 is a reply to message #609005]

Thu, 27 February 2014 23:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

the SELECT employee#... statement must be valid which it it NOT.

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609009 is a reply to message #609006]

Fri, 28 February 2014 00:14

kupstar
Messages: 16
Registered: November 2013
Location: PNG

Junior Member

Blackswan, I ran the select statement which you meant but it ran OK with no errors. Would you be able to point out my invalid code in the query?

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609015 is a reply to message #609009]

Fri, 28 February 2014 00:47

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use SQL*Plus and copy and paste your session.

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609017 is a reply to message #609005]

Fri, 28 February 2014 00:59

_jum
Messages: 577
Registered: February 2008

Senior Member

May be in the TOAD editor the statement BEFORE the given is not properly ended ?
Try your statement in an empty worksheet or better as @Michel stated
Quote:

Use SQL*Plus and copy and paste your session.

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609021 is a reply to message #609005]

Fri, 28 February 2014 01:21

kupstar
Messages: 16
Registered: November 2013
Location: PNG

Junior Member

I am still getting the same error when I tried same query in SQL plus.

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609023 is a reply to message #609021]

Fri, 28 February 2014 01:23

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't you know what COPY & PASTE mean?

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609024 is a reply to message #609023]

Fri, 28 February 2014 01:24

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Also post the result of "select * from v$version".

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609025 is a reply to message #609024]

Fri, 28 February 2014 01:32

kupstar
Messages: 16
Registered: November 2013
Location: PNG

Junior Member

I did copy and paste but am getting the same error. Refer attached for details.

Attachment: error.JPG
(Size: 82.53KB, Downloaded 613 times)

Report message to a moderator

Re: PIVOT - SQL Command not properly ended [message #609026 is a reply to message #609025]

Fri, 28 February 2014 01:34

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

PIVOT was introduced in 11g. There is a reason we ask you ALWAYS post your Oracle version.

Note this text, you don't need to post an image to copy and paste text.

Report message to a moderator