# How to edit underlying SQL in Toad Pivot Grid

**URL:** <https://forums.toadworld.com/t/how-to-edit-underlying-sql-in-toad-pivot-grid/39466>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [May 15, 2017, 10:48am UTC](https://forums.toadworld.com/t/how-to-edit-underlying-sql-in-toad-pivot-grid/39466 "2017-05-15T10:48:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpompey\_562](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mpompey_562/32/120_2.png) [@mpompey\_562](https://forums.toadworld.com/u/mpompey_562)\
**Post date:** [May 15, 2017, 10:48am UTC](https://forums.toadworld.com/t/how-to-edit-underlying-sql-in-toad-pivot-grid/39466/1 "2017-05-15T10:48:51Z")

</div>

Is it possible to see or edit the underlying data in a pivot grid?

I’ve got a previously created Pivot grid that used to open fine.

However now, when I open it nothing is displayed and I get an

Oracle error, invalid number of arguments. ORA-00909.

I was wondering if something was off in the SQL or original

data connection that was used to create the pivot grid.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Filip.Cevela](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/filip.cevela/32/200_2.png) [@Filip.Cevela](https://forums.toadworld.com/u/Filip.Cevela)\
**Post date:** [May 16, 2017, 12:58am UTC](https://forums.toadworld.com/t/how-to-edit-underlying-sql-in-toad-pivot-grid/39466/2 "2017-05-16T00:58:50Z")

</div>

Hi,

if you have your pivot grid with saved Query and with some (old)data you should be able right click to grid and here is an option for editing query.

Filip

---

<div class="post-metadata">

**Author:** ![mpompey\_562](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mpompey_562/32/120_2.png) [@mpompey\_562](https://forums.toadworld.com/u/mpompey_562)\
**Post date:** [May 16, 2017, 6:44am UTC](https://forums.toadworld.com/t/how-to-edit-underlying-sql-in-toad-pivot-grid/39466/3 "2017-05-16T06:44:51Z")

</div>

That may be the problem, I don’t remember the name of the original query

that I used to create the Pivot Grid.

Is there a way to find that out, or should I just delete the grid and start

over?

---

<div class="post-metadata">

**Author:** ![Filip.Cevela](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/filip.cevela/32/200_2.png) [@Filip.Cevela](https://forums.toadworld.com/u/Filip.Cevela)\
**Post date:** [May 17, 2017, 6:45am UTC](https://forums.toadworld.com/t/how-to-edit-underlying-sql-in-toad-pivot-grid/39466/4 "2017-05-17T06:45:02Z")

</div>

I believe that because you see the error your Query should be inside your file. What items do you see in your context menu? Don’t you see Edit Underlying Query?  
 ![Manu.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/2e910296b6b36e5543e0b7ca71ba9cc1ab8ebbad.jpeg)

Can you edit your file manually and check if SQL is not there?