|
From: Keri T. <fur...@gm...> - 2017-05-30 15:15:22
|
Gerd, thank you for your reply. I am not sure what I need to check. I can attach to toad and it doesn't limit my rows, so i wouldn't think it would have something to do with Oracle DB would it? I added the sqlparam Plugin, thanks. it works. Thanks, Keri -----Original Message----- From: Gerd Wagner [mailto:ger...@t-...] Sent: Monday, May 29, 2017 1:26 PM To: Taylor, Keri X.-ND <Ker...@di...>; squ...@li... Subject: Re: [Squirrel-sql-users] Questions about Squirrel SQL Client, please help Taylor, sorry, I can't reproduce your lines limit problem. Does anyone know of a Oracle configuration that causes such behavior? On 'select :var from dual': The only way to parametrize SQLs with SQuirreL is by the sqlparam Plugin. If you installed it you may consult the Plugin's help to see how parameters work. Gerd Am 25.05.2017 um 22:44 schrieb Taylor, Keri X.-ND: > I am totally new to using Squirrel Sql client. I am using *SQuirreL > SQL Client Version 3.7.1*, attaching to Oracle DB. > > 1.I can’t seem to change the Limit Rows, no matter what I choose over > 1000, it limits it to 1000. > > I have also tried to change SQL results in New session properties > > 2.I can’t run parameters. > > Entering: select :var from dual; > > Error: > > Sincerely, > > Keri Taylor > > Technical Analyst > > Disney Parks & Resorts Digital > > (818) 931-2447 | (407) 790-6473 > > /"I can accept failure, but I can't accept not trying." - Michael > Jordan /// > > cid:ima...@01...626E50 > > > > ---------------------------------------------------------------------- > -------- Check out the vibrant tech community on one of the world's > most engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > -- "I can accept failure, but I can't accept not trying." - Michael Jordan |
