Unable to enter long sql commands

jack_2060 has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I am trying to execute a query like this
select pmSuccInConnsRemoteQosClassA , pmSuccOutConnsRemoteQosClassA , pmUnSuccInConnsRemoteQosClassA , pmUnSuccInConnsLocalQosClassA , pmUnSuccOutConnsLocalQosClassA , pmUnSuccOutConnsRemoteQosClassA,RNC from counters where(RNC LIKE '%RNC%' or RNC LIKE 'CR%TX%' or RNC LIKE 'FR%TX%')group by RNC;

but the terminal only excepts a part of it.

select pmSuccInConnsRemoteQosClassA , pmSuccOutConnsRemoteQosClassA , pmUnSuccInConnsRemoteQosClassA , pmUnSuccInConnsLocalQosClassA , pmUnSuccOutConnsLocalQosClassA , pmUnSuccOutConnsRemoteQosClassA,RNC from counters where(RNC LIKE '%R
I guess it a buffer length issue. Is there any way by which i can increase the buffer length of the DBI Shell. Thanks for the help.

Comment on Unable to enter long sql commands

Replies are listed 'Best First'.
Re: Unable to enter long sql commands by trwww (Priest) on Mar 18, 2009 at 18:10 UTC
Hello, I like the DBI shell, too. Provides a consistent interface to all kinds of databases. For long queries, I put them in a file and then do: `USER@dbi:Oracle:SID> /run /path/to/file.sql` This will run the query in the file and show the resultset on the terminal. regards,	[reply] [d/l]
Re: Unable to enter long sql commands by bichonfrise74 (Vicar) on Mar 18, 2009 at 17:47 UTC
I'm not familiar with buffer length issues but you could try to write this in a file and execute it from there.	[reply]